Re: [SQL] Sequential select queries...??

the > query.. then I'd be laughing and then I can complete my task. > > Thanks in advance, > > Mark > > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster > my best regards, Grigoriy G. Vovk ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

Re: [SQL] Functions returning more than one value

L would provide you > with more robust functionality. > > For example, what you want is easily done in Java just by passing the > input parameters as By Reference. > > Opinions on Middleware languages, anyone? > > -Josh Berkus > > my best regards, Grigori

Re: [SQL] REFERENCES constraint

> ---(end of broadcast)------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > my best regards, Grigoriy G. Vovk ---(end of broadcast)--- TIP 3: if posting/re

Re: [SQL] Are circular REFERENCES possible ?

inserted row has 'default' ='t' are there a row which already has 'default' = 't'. May be you will want a trigger for update. And may be for delete - if will deleted 'default' shop - what we should to do? Better will be create a function for delet

RE: [SQL] Delete coloumn

table name, repeat the process of > creating a new table now and copying the data over. > > Hope that helps! > > -Robby Slaughter my best regards, Grigoriy G. Vovk ---(end of broadcast)--- TIP 3: if posting/reading th

Re: [SQL] Meta integrity

sh > > > > __AGLIO DATABASE SOLUTIONS___ >Josh Berkus > Complete information technology [EMAIL PROTECTED] > and data management solutions (415) 565-7293 > for law firms, small businesses

Re: [SQL] Referencing a view?

tional table. May be I've explained not well - ask, I'll type an database structure example, for developers it may be easy way :) my best regards, Grigoriy G. Vovk ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] Referencing a view?

:unknown, org_addresses.name, >org_addresses.street1, org_addresses.street2, org_addresses.city, >org_addresses.state, org_addresses.zip FROM org_addresses; > > So this gives me a view with every address, each with a unique id as I used the same >sequence in both tables. Now what

Re: [SQL] Quick question MySQL --> PgSQL

ou can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > > - Grigoriy G. Vovk ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] two tables - foreign keys referring to each other...

; ON DELETE SET NULL > DEFERRABLE > INITIALLY DEFERRED > ); > COMMIT; > If you have diffarant relation, describe it. - Grigoriy G. Vovk