check if column is NULL (php) - Mailing list pgsql-novice

From Robert Wimmer
Subject check if column is NULL (php)
Date
Msg-id BAY10-F57D08247F4A90B7674D94AD0A90@phx.gbl
Whole thread Raw
Responses Re: check if column is NULL (php)  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
hi,

the question i have is : is it possible to check in a resultSet - as a
result of pg_query("SELECT ...") - if a column in this result can be set to
NULL.

important : it should work with any select statement - if i use only one
table in the select, i know that i could use pg_meta_data.

i need this for a existing formular generator, which works fine, but i cant
check if NULL values are allowed in this form if i dont know it.

to make it easier to understand what  i mean an example   :

$rs = pg_query("SELECT name,adress,value FROM person, bill");
for ($i = 0; $i < pg_num_rows($rs); $i++ ) {
  $myForm->pushInput(pg_field_name($i),pg_field_type($i), ...);
  // can this field be set to NULL?
  }

thanx

sepp

_________________________________________________________________
Hotmails und Messenger-Kommunikation am Handy? Für MSN Mobile kein Problem!
http://www.msn.at/msnmobile/


pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: SQUID Log in PostgreSQL
Next
From: Michael Fuhr
Date:
Subject: Re: check if column is NULL (php)