[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 position function, it's a simple built-in functi

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

2001-07-23 Thread Josh Berkus
Jeff, Karl, Actually, he's confusing 3 functions. See postgresql.org --> user lounge --> interactive docs --> functions and operators --> string functions. -Josh > You are confusing the syntax of two similar functions: > position ('substring' in 'string') > strpos ('string', 'substring'). > I

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

2001-07-23 Thread Jeff Eckermann
You are confusing the syntax of two similar functions: position ('substring' in 'string') strpos ('string', 'substring'). I have a feeling that "position" actually calls "strpos", but I am guessing on that. > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Mo