> -----Original Message-----
> From: Andreas Pflug [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 07, 2004 11:17 AM
> To: Dann Corbit
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Dumb question: How do I determine
> programmatically if a column is nullable?
>
>
> Dann Corbit wrote:
>
> > What API call can I make to find out if a column is nullable or not?
> >
>
> SELECT attnotnull FROM pg_attribute ...
> see documentation "Internals/System Catalogs"
Is there a way do do it when I have some arbitrary query that returns a
result set?
In other words, I will be passed a SQL query. I don't want to have to
parse it myself.
Rather, I want to know (for the bound columns) if a column is nullable
or not.
Is the functionality available in [for example] libpq?
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
