Re: [SQL] Question about One to Many relationships

Child table references a not-existing table: ('band' insted of 'bands') Error: ERROR: relation "band" does not exist > CREATE TABLE bands ( > CREATE TABLE bands_on_album ( - - - > band_id integer REFERENCES band (id), - - - Reg

Re: [SQL] How can I selet rows which have 2 columns values cross equal?

a = b.b and a.b = b.a order by id Regards, Milorad Poluga -- ----------- Milorad Poluga HK CORES Beograd, Makenzijeva 31 [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 1: if posting/re

Re: [SQL] Interval subtracting

Thank you all for suggestions and links. Currently, I am working on  PostgreSQL 8.0.4., so I cannot use justify_*() functions. Regards, Milorad Poluga [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

Re: [SQL] Interval subtracting

On Saturday 18 February 2006 15:24, Milen A. Radev wrote: > Milorad Poluga написа: > > Hi all, > > > > Is there something incorrect in the above query ? > > SELECT '10 years 1 mons 1 days'::interval - '9 years 10 mons

[SQL] Interval subtracting

linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3) / Thanks a lot, Milorad Poluga --- [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to