From: Rajesh Kumar Mallah. <mallah@trade-india.com>
To: Gabriel Dovalo Carril <dovalo@terra.es>
To: Jeff Eckermann <jeff_eckermann@yahoo.com>
Cc: Lista SQL de postgres <pgsql-sql@postgresql.org>
Subject: Re: Functions with dynamic queries
Date: Sun, 26 May 2002 15:55:59 +0530
Message-ID: <200205261555.59986.mallah@trade-india.com> (raw)
In-Reply-To: <3CEEE4A5.EF729BB@terra.es>
References: <20020524135106.99232.qmail@web20802.mail.yahoo.com>
<3CEEE4A5.EF729BB@terra.es>
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.
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: mallah@trade-india.com, dovalo@terra.es, jeff_eckermann@yahoo.com
Subject: Re: Functions with dynamic queries
In-Reply-To: <200205261555.59986.mallah@trade-india.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