check if column is NULL (php)

From: "Robert Wimmer" <seppwimmer(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: check if column is NULL (php)
Date: 2004-12-11 22:51:08
Message-ID: BAY10-F57D08247F4A90B7674D94AD0A90@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2004-12-12 01:17:24 Re: check if column is NULL (php)
Previous Message Michael Fuhr 2004-12-11 19:57:17 Re: SQUID Log in PostgreSQL