Bruce Momjian wrote:
I am just writing the EXISTS section from my book. I don't think it
matters what fields are returned from an EXISTS subquery. If I am
wrong, someone please let me know.
Celko also writes (in his chapter on EXISTS in "SQL for Smarties"):
"In general the SELECT * option
Hello,
Sure you can use arrays as returned results in your function.
regards.
Omid Omoomi
From: Peter Eisentraut [EMAIL PROTECTED]
To: Dale Anderson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: [GENERAL] PSQL Function() help
Date: Wed, 12 Jan 2000 04:58:53 +0100
On 2000-01-12,
Hi fellows !
I would only want to ask some questions concerning table-locking levels
and isolation levels:
* First of all: should I assume that AccessXXX modes imply locking
the complete table and Row imply locking only the rows which have
been accessed ? Will then the conflicts be
Sarah Officer wrote:
How about using a union?
select cc.com_cat_long, co.company_name
from company_category cc, company co
where cc.com_cat_abbr = co.com_cat_abbr
union
select 'unknown' as com_cat_long, company_name
from company
where com_cat_abbr is null;
Yes, would be the best way
Bruce Momjian wrote:
I am just writing the EXISTS section from my book. I don't think it
matters what fields are returned from an EXISTS subquery. If I am
wrong, someone please let me know.
Celko also writes (in his chapter on EXISTS in "SQL for Smarties"):
"In general the SELECT