Обсуждение: null : Компания Postgres Professional

От:

"Doug Smith" <doug@the-bridge.net>

Дата:

26 октября 1998 г. в 15:48:24

Does anybody know if 'LEFT','RIGHT','SUBSTR' are working with psql,

I keep getting the magical parse error at or near 'left'.

Thanks

Re:

От:

Sferacarta Software <sferac@bo.nettuno.it>

Дата:

27 октября 1998 г. в 08:35:38

Hello Doug,

lunedì, 26 ottobre 98, you wrote:

DS> Does anybody know if 'LEFT','RIGHT','SUBSTR' are working with psql,
DS> I keep getting the magical parse error at or near 'left'.
DS> Thanks

There's the SQL92 substring function:

SUBSTRING(string [FROM start] [FOR chars])


Jose'