[SQL] except on nulls?

I had the following weird experience. Hopefuly iy's my ignorance on the matter (but I sort of think this worked before...) On PostgreSQL 7.0.2, I have an database with two tables, holding different versions of the data set (some rows missing in one of the tables). Example is: CREATE TABLE "tes

Re: [SQL] HELP! ... pg_locale ???

Sandis Jerics <[EMAIL PROTECTED]> writes: > As result, now all queries, written inside the php code on multiply lines, > returns the following: > ERROR: parser: parse error at or near " " At a guess, you're having trouble with newline representations (Unix convention is \n only, DOS/Windows conv

Re: [SQL] renaming columns... danger?

Subject:[SQL] renaming columns... danger? > I just discovered that doing an alter table ... alter > column (to rename a column) does not do a complete > rename throughout the database. > shouldn't rename update any index and key definitions? > I'm very frightened right now, beca

Re: [SQL] except on nulls?

Daniel Kalchev <[EMAIL PROTECTED]> writes: > [ EXCEPT behaves oddly in the presence of NULLs ] Yup, it does, because it's implemented like NOT IN, and NOT IN on a set containing nulls can never return 'true', only 'false' or 'unknown'. For example, 1 NOT IN (1,2,NULL) is clearly F

[SQL] benchmarks

hi all, lately at work there has been a debate over mysql versus postgres im just looking for independent benchmarks i personally love postgres at work they like mysql currently we are investigating other possible db solutions and they are looking at oracle, i think we could save a lot of d

[SQL] .

Hi all,     I tried:SELECT * FROM DB1.MY_TABLE;from DB2 and it did not like the syntax.  I assume that you cannot select across database/schemas.Is this correct? Shiva

Re: [SQL] benchmarks

> im just looking for independent benchmarks Even if there exist independent benchmarks, there are none being applicable to real life. > i personally love postgres > at work they like mysql > > currently we are investigating other possible db solutions Uh? You _love_ this and they

Re: [SQL] renaming columns... danger?

Just tested this on latest devel. version, and there does seem to be a problem. []$ psql test Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate