Yea i got it. I did the uppercase before i came to the select and it works
well. *Fingers crossed*
Thanks for all the help.
Ohh and Happy Eater to everyone in the mailing list ^^
Shavonne Wijesinghe
- Original Message -
From: "A. Kretschmer" <[EMAIL PROTECTED]>
To:
Sent: Thur
Hi all,
I want to update the values of a column with the
result of a function that requires information
from another table. Specifically it needs a
minium and maximum value from another table.
How do I perform the update query?
Below is my attempt but it doesn't work. The
"bhlineid" is my prim
I would like to be able to drop a schema with all of its objects, but
don't want to accidentally drop objects that are in other schemas. If
there are such objects I'd prefer the drop to fail. If I use DROP SCHEMA
FOO CASCADE I run the risk of dropping objects from other schemas that
depend on objec
"George Pavlov" <[EMAIL PROTECTED]> writes:
> As an immediate solution can anyone share a comprehensive query to
> INFORMATION_SCHEMA/PG_CATALOG that can be used to check for any
> cross-schema dependencies and halt before issuing a DROP with a CASCADE?
Issue the DROP without CASCADE and read the
> > As an immediate solution can anyone share a comprehensive query to
> > INFORMATION_SCHEMA/PG_CATALOG that can be used to check for any
> > cross-schema dependencies and halt before issuing a DROP
> with a CASCADE?
>
> Issue the DROP without CASCADE and read the error message.
Well, to be pre
