Re: plpgsql question - Mailing list pgsql-sql

From Josh Berkus
Subject Re: plpgsql question
Date
Msg-id 200311081614.55035.josh@agliodbs.com
Whole thread Raw
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: plpgsql question
Next
From: ow
Date:
Subject: pg 7.4.rc1, Range query performance