From: Jeff Eckermann <jeff_eckermann@yahoo.com>
To: Rajesh Kumar Mallah. <mallah@trade-india.com>
To: Gabriel Dovalo Carril <dovalo@terra.es>
Cc: Lista SQL de postgres <pgsql-sql@postgresql.org>
Subject: Re: Functions with dynamic queries
Date: Tue, 28 May 2002 10:04:07 -0700 (PDT)
Message-ID: <20020528170407.25787.qmail@web20806.mail.yahoo.com> (raw)
In-Reply-To: <200205261555.59986.mallah@trade-india.com>
Rajesh,
Thanks for telling me that I am _not_ going crazy.
Because I could not see any reason why Gabriel's
scripts should not work.
Gabriel, I have two remaining suggestions:
1. Maybe you have stuff in your database that you do
not expect. Perhaps try running this via a
newly-created, empty database?
2. If that still doesn't work, you probably have a
problem with your installation. If you post details
of your OS platform, PostgreSQL version etc., some
guru on the list may be able to suggest something.
Sorry, that's the best I can think of.
Jeff
--- "Rajesh Kumar Mallah." <mallah@trade-india.com>
wrote:
>
> Hi Gabriel,
>
> sorry for the late response,
>
> I tried both the scripts and they do work.
>
> psql -h 192.168.0.11 -U tradein test -f b.sql
> DROP
> psql:b.sql:6: NOTICE: CREATE TABLE / PRIMARY KEY
> will create implicit index 'people_pkey' for table
> 'people'
> CREATE
> INSERT 27856939 1
> INSERT 27856940 1
> DROP
> CREATE
> get_age
> ---------
> 10
> (1 row)
>
> Hmm, am i missing anything ?
>
> mallah.
>
>
>
>
>
>
>
> Try attached scripts. They are only examples, (no
> real data)
> They are very, very simple and fails in the same
> situation.
>
> > The only difference between then is line 19
> >
> > (func_error.sql)
> > Select people.age into person
> >
> > (func_nodata.sql)
> > Select max(people.age) as age into person
> >
> >
> > The first one returns:
> > ERROR: record person is unassigned yet
> >
> > And the second one:
> > get_age
> > ---------
> >
> > (1
> > row)
>
> --
> Rajesh Kumar Mallah,
> Project Manager (Development)
> Infocom Network Limited, New Delhi
> phone: +91(11)6152172 (221) (L) ,9811255597 (M)
>
> Visit http://www.trade-india.com ,
> India's Leading B2B eMarketplace.
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
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: jeff_eckermann@yahoo.com, mallah@trade-india.com, dovalo@terra.es
Subject: Re: Functions with dynamic queries
In-Reply-To: <20020528170407.25787.qmail@web20806.mail.yahoo.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