[SQL] Re: position(text,text) function

2001-07-24 Thread Karl Orbell
Many thanks for all of the assistance on this question. I can't say I've ever seen the "a in b" syntax in postgres, but you live and learn. ;-) Thanks again. Karl. In article <[EMAIL PROTECTED]>, Karl Orbell wrote: > I'm having trouble using the positio

[SQL] position(text,text) function

2001-07-23 Thread Karl Orbell
of constants casting to text and using it in other contexts, (ie. in functions, not just in a select). What am I doing wrong? Is this not the correct syntax for a two argument function? test=# select position('hello','el'); ERROR: parser: parse error at or near ","