From: Josh Berkus <josh@agliodbs.com>
To: Rich Seiersen <rich67dev@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: plpgsql question
Date: Sat, 8 Nov 2003 16:14:55 -0800
Message-ID: <200311081614.55035.josh@agliodbs.com> (raw)
In-Reply-To: <Law9-F18aKc22ZNg1Ji0002923c@hotmail.com>
References: <Law9-F18aKc22ZNg1Ji0002923c@hotmail.com>
Rich,
> That was my thought - I was fairly sure I fixed it though..... Do, really
> need to be specific in terms of type in terms of int, or can I put numeric,
INT and numeric are fairly different, and I believe that SRF return types are
very fussy about data types; I wouldn't be surprised if you got an error for
using an INT4 in place of an INT8.
> and for varchar(30) I can just put varchar in my type definition.
That I don't think will be a problem; varchar limits are indifferently
supported anyway.
--
Josh Berkus
Aglio Database Solutions
San Francisco
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, rich67dev@hotmail.com
Subject: Re: plpgsql question
In-Reply-To: <200311081614.55035.josh@agliodbs.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