Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6NJ6Df24363 for ; Mon, 23 Jul 2001 15:06:13 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 89937; Mon, 23 Jul 2001 12:06:11 -0700 From: "Josh Berkus" Subject: Re: RE: position(text,text) function To: Jeff Eckermann , "'karl@tecc.co.uk'" , pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Mon, 23 Jul 2001 12:06:11 -0700 Message-ID: In-Reply-To: <08CD1781F85AD4118E0800A0C9B8580B094B57@NEZU> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/317 X-Sequence-Number: 4126 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 have a feeling that "position" actually calls "strpos", but I am > guessing > on that. > > > -----Original Message----- > > From: karl@tecc.co.uk [SMTP:karl@tecc.co.uk] > > Sent: Monday, July 23, 2001 9:27 AM > > To: pgsql-sql@postgresql.org > > Subject: position(text,text) function > > > > I'm having trouble using the position function, it's a simple > built-in > > function. > > > > It returns the index of a substring within a main string. > > > > But, I just can't get it to work, it always gives this silly parser > error. > > I've tried it in a variety of ways with variables instead 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 "," > > > > > > Karl Orbell. > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco