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), - - - Regards, Milorad Poluga [EMAIL PROTECTED

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

Poluga -- --- Milorad Poluga HK CORES Beograd, Makenzijeva 31 [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send

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

[SQL] Interval subtracting

(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 choose an index scan