pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: pl/pgsql - code review + question
Date: Thu, 19 Jul 2001 08:19:55 -0700
Message-ID: <web-88026@davinci.ethosmedia.com> (raw)
In-Reply-To: <003c01c1103a$e9ca9580$1001a8c0@archonet.com>

Richard,

> > Josh - if I try and do OFFSET at the same time (presumably it's the
> same
> > change) do you fancy acting as a sanity test site?
> 
> What am I talking about - OFFSET is going to be parsed by the SQL
> parser not
> the plpgsql parser.

Not so, not so!

Try the following two PL/pgSQL functions:

DECLARE
	h INT;
	k INT;
	a_row a%ROWTYPE;
BEGIN
	h := 1;
	k := 3;
	SELECT * FROM a INTO a_row
	ORDER BY a.1
	LIMIT 1 OFFSET (h + k);
END;

	... blows up, but  ...


DECLARE
	h INT;
	k INT;
	a_row a%ROWTYPE;
BEGIN
	h := 1;
	k := (3 + h);
	SELECT * FROM a INTO a_row
	ORDER BY a.1
	LIMIT 1 OFFSET k;
END;

 ... works.


As far as I can tell, PL/pgSQL is not evaluating the expression before
passing it on to the SQL parser.  Or is the SQL parser supposed to
accept (1 + 3) ....

Oh, I see what you mean.   Sorry!  Should I bug-traq this problem?  

-Josh


______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







view thread (14+ messages)  latest in thread

Message-ID: <web-88026@davinci.ethosmedia.com>
Permalink:  ../web-88026@davinci.ethosmedia.com/
Also on:    postgresql.org/message-id/web-88026@davinci.ethosmedia.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: josh@agliodbs.com, dev@archonet.com
  Subject: Re: pl/pgsql - code review + question
  In-Reply-To: <web-88026@davinci.ethosmedia.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox