Re: [SQL] comparing nulls

2004-01-20 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Kenneth Gonsalves) would write: > On Tuesday 20 January 2004 19:26, Chris Bowlby wrote: >> Under 7.3.x this option was removed, you need to test via: >> >> SELECT * from table where field IS NULL; > thanx - works in both 7.1 and 7.3 - wh

Re: [SQL] Fetching a single column from a record returning function

2004-01-20 Thread Joe Conway
Kumar wrote: select * from .fn_email(1) as (email_folder_id int4,email_folder_name varchar,descrip varchar,msgcount int8,unreadcount int8,size int8); Is it possible to fetch only one column (the 'msgcount') from the function. Because I am interested in SUM(msgcount). Please shed some light. What

Re: [SQL] Fetching a single column from a record returning function

2004-01-20 Thread Tom Lane
"Kumar" <[EMAIL PROTECTED]> writes: > select * from fn_email(1) > as (email_folder_id int4,email_folder_name varchar,descrip varchar,msgcount > int8,unreadcount int8,size int8); > Is it possible to fetch only one column (the 'msgcount') from the function.= > Because I am interested in SUM(msgcou

Re: [SQL] comparing nulls

2004-01-20 Thread Jeff Eckermann
--- Guy Fraser <[EMAIL PROTECTED]> wrote: > Kenneth Gonsalves wrote: > > >On Tuesday 20 January 2004 19:26, Chris Bowlby > wrote: > > > > > >>Hi Ken, > >> > >> Under 7.3.x this option was removed, you need to > test via: > >> > >> SELECT * from table where field IS NULL; > >> > >> > >thanx -

Re: [SQL] comparing nulls

2004-01-20 Thread Guy Fraser
Kenneth Gonsalves wrote: On Tuesday 20 January 2004 19:26, Chris Bowlby wrote: Hi Ken, Under 7.3.x this option was removed, you need to test via: SELECT * from table where field IS NULL; thanx - works in both 7.1 and 7.3 - why do these guys keep fooling around with these thangs? Stan

Re: [SQL] comparing nulls

2004-01-20 Thread Chris Bowlby
To achieve a higher level of SQL compliancy.. On Tue, 2004-01-20 at 10:24, Kenneth Gonsalves wrote: > On Tuesday 20 January 2004 19:26, Chris Bowlby wrote: > > Hi Ken, > > > > Under 7.3.x this option was removed, you need to test via: > > > > SELECT * from table where field IS NULL; > thanx - wo

Re: [SQL] comparing nulls

2004-01-20 Thread Kenneth Gonsalves
On Tuesday 20 January 2004 19:26, Chris Bowlby wrote: > Hi Ken, > > Under 7.3.x this option was removed, you need to test via: > > SELECT * from table where field IS NULL; thanx - works in both 7.1 and 7.3 - why do these guys keep fooling around with these thangs? -- regards kg http://www.ooty

Re: [SQL] comparing nulls

2004-01-20 Thread Reinoud van Leeuwen
On Tue, Jan 20, 2004 at 07:13:12PM +0530, Kenneth Gonsalves wrote: > in postgres7.1 i had a table where an integer field could be null. There was > no default value. a select statement like so: > 'select * from table where field = null' > would give all the rows where that field had no value. > o

Re: [SQL] Database diagram

2004-01-20 Thread Luis Sousa
Ganesan Kanavathy wrote: I have a postgres database with many tables. How do I create database diagram? Are there any free tools available to create database diagram from pgsql database? Regards, Ganesan ---(end of broadcast)--- TIP 8: explain ana

Re: [SQL] comparing nulls

2004-01-20 Thread D'Arcy J.M. Cain
On January 20, 2004 08:43 am, Kenneth Gonsalves wrote: > in postgres7.1 i had a table where an integer field could be null. There > was no default value. a select statement like so: > 'select * from table where field = null' > would give all the rows where that field had no value. > on porting to 7

Re: [SQL] comparing nulls

2004-01-20 Thread Chris Bowlby
Hi Ken, Under 7.3.x this option was removed, you need to test via: SELECT * from table where field IS NULL; On Tue, 2004-01-20 at 09:43, Kenneth Gonsalves wrote: > in postgres7.1 i had a table where an integer field could be null. There was > no default value. a select statement like so: >

[SQL] comparing nulls

2004-01-20 Thread Kenneth Gonsalves
in postgres7.1 i had a table where an integer field could be null. There was no default value. a select statement like so: 'select * from table where field = null' would give all the rows where that field had no value. on porting to 7.3.2, this doesnt work. How to do this? -- regards kg http://

Re: [SQL] Database diagram

2004-01-20 Thread Gregory S. Williamson
ERWin is likely to be expensive, judging by the cost for an Informix license. It is also a serious tool; has its quirks but can be used to reverse engineer as well as define a database with detailed support for triggers and the like. Greg Williamson DBA GlobeXplorer LLC -Original Message--

Re: [SQL] Database diagram

2004-01-20 Thread Roberto Mello
On Tue, Jan 20, 2004 at 02:38:12PM +0800, Ganesan Kanavathy wrote: > I have a postgres database with many tables. > > How do I create database diagram? Are there any free tools available to > create database diagram from pgsql database? There are several such tools: http://www.rbt.ca/autodoc/ db

[SQL] Fetching a single column from a record returning function

2004-01-20 Thread Kumar
Hi Friends,   Postgres 7.3.4 on RH Linux 7.2   I am using a record variable inside a functions and fetch the result via the follow command   select * from .fn_email(1) as (email_folder_id int4,email_folder_name varchar,descrip varchar,msgcount int8,unreadcount int8,size int8);     Is it possi

Re: [SQL] Database diagram

2004-01-20 Thread Denis
Hi Ganesan, You can try ERWin (by CA). It creates Logical data model of the database. (though.. i haven't used it..) HTH Thanx Denis - Original Message - From: "Ganesan Kanavathy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 20, 2004 12:08 P