> 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
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 be
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 so
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
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 * opti
