At 19:22 24/09/00 -0500, Dominic J. Eidson wrote:
>
>In these cases, is NULL = 0? - What if it returns the UID for "root"
>(typically UID 0)... I think an error message should/would be better in
>this case.
>
No NULL is NULL, a special value that usually means 'nothing found'.
-
On Sun, 24 Sep 2000, Philip Warner wrote:
> Two routines do eccentric things when they can't find required supporting
> data:
>
> pg_get_userbyid
>
> returns 'unknown (UID=)' when the UID does not exist.
[Snip]
> The proposal is to return NULL in the above cases - in the final case,
> pro
Philip Warner <[EMAIL PROTECTED]> writes:
> pg_get_viewdef
> returns 'Not a view' when passed a non-existant or non-view table
> it also signals errors when the underlying metadata can not be found.
> The proposal is to return NULL in the above cases - in the final case,
> probably also
On Sun, 24 Sep 2000, Indraneel Majumdar wrote:
> Does any one know how I may select between two databases running on same
> machine or on different machines eg.
>
> select colA1 from tableA1 where colA2 in (select colB1 from tableB1);
>
> here tableA1 and tableB1 are in different databases. The
Not working, but thanks anyway. Can anyone point out the relevant area of
the source where queries are handled?
Thanks,
Indraneel
On Sun, 24 Sep 2000, Fredrick Bartlett wrote:
> Not sure if same can be accomplished with different servers.
> Try the following for database's on one server, use
Not sure if same can be accomplished with different servers.
Try the following for database's on one server, use alias & dot notation...
select a1.colA1 from
myDatabase1.tableA1 a1
where a1.A2 in (select b1.colB1 from myDatabase2.tableB1 b1)
Indraneel Majumdar wrote:
> Hi,
>
> Does any one kno
Hi,
Does any one know how I may select between two databases running on same
machine or on different machines eg.
select colA1 from tableA1 where colA2 in (select colB1 from tableB1);
here tableA1 and tableB1 are in different databases. The two databases
might be under the same postmaster or on
