from:"Ulf Mehlig"

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

2000-07-26 Thread Ulf Mehlig

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] Negating the list of selected rows of a join

1999-03-14 Thread Ulf Mehlig

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

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

1999-03-14 Thread Ulf Mehlig

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

1999-03-14 Thread Ulf Mehlig

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 --

[GENERAL] information about primary key from sys tabs

1999-03-04 Thread Ulf Mehlig

), 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] PostgreSQL and WWW

1998-11-29 Thread Ulf Mehlig

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

Re: [GENERAL] Case insensitive "contains" search

1998-11-09 Thread Ulf Mehlig

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] Problem with aggregates and group by

1998-10-30 Thread Ulf Mehlig

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] select and join

1998-10-26 Thread Ulf Mehlig

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] date null

1998-10-26 Thread Ulf Mehlig

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 -- =