[GENERAL] "alter table rename" does not update constraints

f postgreSQL 7.0.2, i386 Linux 2.2.15/Redhat-6.something -- ========== Ulf Mehlig<[EMAIL PROTECTED]> Center for Tropical Marine Ecology/ZMT, Bremen, Germany --

Re: [GENERAL] Problem with getting the right order

ther way round. Hope it helps! Ulf -- ========== %Ulf Mehlig <[EMAIL PROTECTED]> !%%% Projekt "MADAM" <[EMAIL PROTECTED]> %!% ---| %%%

Re: [GENERAL] aggregate question

g-statements, I would be very happy ;-) Thanks in advance, Ulf -- == %%%%% Ulf Mehlig <[EMAIL PROTECTED]> !%%% Projekt "MADAM&

Re: [GENERAL] date null

pe (float, int etc.): The first says that the value of "something" in that row is zero, the second, that there isn't any value assigned to "something"in that row. With value zero you can do calculations (some! ;-), with "null", you can't. Ulf -- =

Re: [GENERAL] select and join

too, because this column name is not unique. Anyway, I did not test anything, and maybe I overlooked something important ... I hope it helps ... Yours, Ulf -- == %Ulf Mehlig <[EMAIL PROTECTED]> !%%% Projekt "MADA

Re: [GENERAL] Problem with aggregates and group by

perations like joins. Maybe you find it in a library where you can copy the interesting pages ... But I'm sure there are people reading the list who can give better tips ;-) Hope it helps, Ulf -- ===

Re: [GENERAL] Case insensitive "contains" search

some nice annoying little differences in "to-quote-or-not-to-quote" sections ... Anyway, there seem to be quite a lot of introductory texts (including a whole O'Reilly Book dedicated to Regular Expressions, which I saw in the book store), maybe it's worth to have a look at th

Re: [GENERAL] PostgreSQL and WWW

ver. Hope it helps, Ulf P.S.: > P.S.: you can write me in russian - it's my native lang. :) unfortunately not mine ;-) -- == %Ulf Mehlig <[EMAIL PROTECTED]> !%%% Projekt "MADAM" <[EMAIL PRO

[GENERAL] information about primary key from sys tabs

), I *can* distinguish between 'primary key' and other unique indexes. Thank you for your help, Ulf -- == Ulf Mehlig<[EMAIL PROTECTED]> Center for Tropical Marine Ecology/ZMT, Bremen, Germany --

Re: [GENERAL] Negating the list of selected rows of a join

robably will help you is the construction of a so-called 'sub-select' in the where clause: SELECT name FROM table_a WHERE name NOT IN (SELECT name FROM table_b); Hope it helps! Ulf -- == Ulf Mehlig<[EMAIL PROTECTED]> Center for Tropical Marine Ecology/ZMT, Bremen, Germany --

Re: [GENERAL] Negating the list of selected rows of a join

s *any* pair of equal names in both tables?! Have a nice (sun)day, Ulf -- ====== Ulf Mehlig<[EMAIL PROTECTED]> Center for Tropical Marine Ecology/ZMT, Bremen, Germany --

Re: [GENERAL] Negating the list of selected rows of a join

Clark Evans <[EMAIL PROTECTED]>/Ulf Mehlig <[EMAIL PROTECTED]> wrote: > > > Hope this will do the trick. > > > > Maybe not -- doesn't that mean, that the query won't return a > > single row in case there is *any* pair of equal names in bo