[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] plpgsql question
From:       Josh Berkus <josh () agliodbs ! com>
Date:       2003-11-09 0:14:55
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html
[prev in list] [next in list] [prev in thread] [next in thread]