Re: [SQL] Constraint->function dependency and dump in 7.3

Dear Gabor, I meant that if the schema of the given database is not altered frequently it can be a considerable solution keeping the schema in a separate file. When it is altered you must make a new one, but just once per schema modifications. I don't think that it is a painful thing to write a scr

Re: [SQL] Constraint->function dependency and dump in 7.3

Hi Gábor! I had the same problem and someone pointed me the right direction. I tried to define a table default clause refering a function. Reloading the dump file an error messaged raised up saying that the referred function doesn't exist. This is because dumping out the schema pg_dump pushes out

Re: [SQL] Postgres - Delphi Application

Both link work nicely, thanks. I don't know what could be the problem with the others. But it's not important by now Thank you. -- Csaba - Original Message - From: "Tomasz Myrta" <[EMAIL PROTECTED]> To: "Együd Csaba" <[EMAIL PROTECTED]&g

Re: [SQL] Getting all rows even if not a member of any groups

Dear All, thank you for your help, it was really efficient. I'll get by with it now. Thanks. -- Csaba - Original Message - From: "Bruno Wolff III" <[EMAIL PROTECTED]> To: "Együd Csaba" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday

Re: [SQL] Getting all rows even if not a member of any groups

Bruno, > Please don't reply to messages to start a new thread. sorry, I will never do such things in the future. > select t_productgroups.name as pgroup, > t_products.id as productid > from t_products > left join (t_prod_in_pgr > join t_productgroups on (t_productgroups.id =

Re: [SQL] Postgres - Delphi Application

Tomasz, it seems to be interesting for me as well, but actually I can't download a file from the given url. I just click on the binary zip link, but nothing happen. How should I click? :) Thanks, -- Csaba - Original Message - From: "Tomasz Myrta" <[EMAIL PROTECTED]> To: "murali" <[EMAIL P

[SQL] Getting all rows even if not a member of any groups

Hi, I have a product table identified by its id field. There is a productgroups table with productisd, productgroupid fields. And I have a prod_in_pgr (productid, productgroupid) table which describes the membership of productgroups. Each product can be a member of zero or more productgroups, but o

[SQL] Join or Where?

Title: Urgent Help : Use of return from function/procedure. Hi,could anybody tell me what can be the difference between these queries?There are a big difference but I can't understand the reasons. For somereasons the firs query calculates getup column in a wrong way. It allwaysdevides with 10

Re: [SQL] Getting one row for each subquery row...?

Thank you Tomasz, this last one seems to be good - with a little change. select distinct t_stockchanges.productid, t_productgroups.name as pgroup from t_stockchanges join t_prod_in_pgr using (productid) join t_productgroups on (t_productgroups.id=productgroupid); Thank you again. By, -- Csaba >

[SQL] Getting one row for each subquery row...?

Hi All, here are my three tables. I wold like to list them in the following way: I need all the columns from t_stockchanges, and one field for the productgroup the t_stockchanges.productid belongs to. But one product can belong to many groups, so i would need one row for each group for each p