pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Unnikrishnan Menon <unnikrishnan.menon@chennai.transys.net>
To: Ross J. Reedstrom <reedstrm@rice.edu>
To: pgsql-sql@postgresql.org
Subject: Re: Problems with PL/PGSQL - functions
Date: Mon, 14 Jan 2002 10:48:31 +0530
Message-ID: <003401c19cba$ebea5e60$e90aa8c0@UNNIKRISHNAN> (raw)
References: <008801c19c3f$d588ce70$e90aa8c0@UNNIKRISHNAN>
	<20020113161931.GB7025@rice.edu>

Hi Ross,

Iam sorry. when I wrote nextval(sequence) in the Select query I actually
meant the same table that I had created before. The question is that the
queries do not execute. They give errors in the first one and in the second
it gives a Not yet implmented error if i use Select into. The select as
query executes but does not return the value required in a variable.

Any idea on the second question on constraints :

What command or table gives the details of the constraints created other
than check constraints.

Thanx
Unni

----- Original Message -----
From: "Ross J. Reedstrom" <reedstrm@rice.edu>
To: "Unnikrishnan Menon" <unnikrishnan.menon@chennai.transys.net>
Cc: <pgsql-sql@postgresql.org>
Sent: Sunday, January 13, 2002 9:49 PM
Subject: Re: [SQL] Problems with PL/PGSQL - functions


> On Sun, Jan 13, 2002 at 08:07:27PM +0530, Unnikrishnan Menon wrote:
> > Hi,
> >
> > I have a couple of problems :
> >
> > 1. I create a temporary table using the following method within a
function:
> >
> >     query := ''Create table S_'' || nextval(sequence) || '' ( abc
integer, xyz varchar)'';
> >     Execute query;
> >     This query does create a table. But when I'am unable to access the
records in the table. I use the following methods:
> >
> >     a. Select xyz into variable from S_''|| nextval(sequence)||'' where
abc = (some counter value) ;
> >     b. query1 := '' Select xyz as variable from S_''||
nextval(sequence)||'' where abc = (some counter value) '' ;
> >         Execute query1;
>
> Right, because each one increments the sequence. Try substituting
currentval().
> Oh, and you might want to create the table as a temp table, in a
transaction,
> so it'll go aeway automatically for you at the end of the transaction.
>
> Ross




view thread (4+ messages)

Message-ID: <003401c19cba$ebea5e60$e90aa8c0@UNNIKRISHNAN>
Permalink:  ../003401c19cba$ebea5e60$e90aa8c0@UNNIKRISHNAN/
Also on:    postgresql.org/message-id/003401c19cba$ebea5e60$e90aa8c0@UNNIKRISHNAN

 · 

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: unnikrishnan.menon@chennai.transys.net, reedstrm@rice.edu
  Subject: Re: Problems with PL/PGSQL - functions
  In-Reply-To: <003401c19cba$ebea5e60$e90aa8c0@UNNIKRISHNAN>

* 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