Re: [SQL] Encode

2007-03-19 Thread Jure Kodzoman
e to change encoding of your client. It might be of help to you, depending on why you want to change encoding. SET CLIENT_ENCODING TO 'LATIN2'; where you would change latin2 with encoding you wish to use. You can find more info on this topic on http://www.postgresql.org/docs/8.2/stat

Re: [SQL] import CSV file

2007-03-13 Thread Jure Kodzoman
r reading: No such file or > directory > > The file exists. Do I need to escape the quotes? > Try setting the permissions chmod a+r /tmp/FTSE.csv Best regards, Jure Kodzoman ---(end of broadcast)--- TIP 1: if posting/reading throug

Re: [SQL] Data Entry and Query forms

2006-06-30 Thread Jure Kodzoman
> > Before continuing our Plans, I need to know how can I do with > PostgreSQL in order to have Data Entry and Query Forms on clients side > (How can I design Data Entry and Query Forms). > Hy. You could try using BOND framework which works for both linux and win32. It is rather bad documented

[SQL] GROUP BY issue

2006-04-10 Thread Jure Kodzoman (Dhimahi)
Hy list. I have 3 tables: performance event pool_performance each event has it's performances, and can be assigned to one or more pools. pool_performance holds performance_id, pool_id and from_date performance has event_id and performance_id as primary key what I want to do is select min(p

[SQL] Checking if date is inside date range

2006-03-17 Thread Jure Kodzoman
Hy list, I would like to check if date is inside a given date range. For instance if date range is datestart column: 10/10/2005 dateend column: 10/20/2005 I would like to return columns for date = 10/15/2005 and not if i enter let's say date = 10/21/2005 thanks for your help, Jure Kod

Re: [SQL] Checking if date is inside date range

2006-03-17 Thread Jure Kodzoman
> I would like to check if date is inside a given date range. stupid question :) sorry for bothering you. Jure > ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[SQL] constrains problem...

2005-12-07 Thread Jure Kodzoman
Hy list, i would like to ask you for help. I have 3 tables. table1 has primary key 't1code' and table_rel is 'many to many' relation for table2. table2 primary key is 't2code' table_rel has two fields: 't1code' and 't2code', where both of them together make a primary key for the rela