From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | hackers(at)postgreSQL(dot)org |
Subject: | isnull() or is it? |
Date: | 1998-12-09 00:56:47 |
Message-ID: | XFMail.981208195647.vev@michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
A while back there was some discussion about NULL. Right now I'm trying
to do something that 'Practical SQL' seems to think is normal yet brings up
the questions from earlier conversations. I'm querying two tables where
if the second table (specialprice) has nothing that matches sku, I don't
care. IIRC this is how I do it in Sybase (don't have the actual calls in
front of me so I don't know if I'm mistaken). The following select call:
select
products.image,products.sizes,products.colors,products.weight,products.categor
y,products.accessories,products.saleprice,products.ourcost,products.descriptio
n,isnull(specialprice.specialprice,0.0) from products,specialprice where
products.sku = '28434' and (specialprice.sku = '28434' or specialprice is
null);
results in this:
ERROR: No such function 'isnull' with the specified attributes
I thought that isnull() was something that existed in PostgreSQL 6.4, am
I wrong or is it implemented differently than Sybase? Or am I not making
sense (it should be easy to explain if I'm not)?
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
# include <std/disclaimers.h> TEAM-OS2
Online Searchable Campground Listings http://www.camping-usa.com
"There is no outfit less entitled to lecture me about bloat
than the federal government" -- Tony Snow
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-12-09 01:24:19 | Re: [HACKERS] isnull() or is it?t |
Previous Message | Brook Milligan | 1998-12-08 20:53:24 | Re: [HACKERS] Proposed autoconf change: rip out search for 'install' |