Re: [GENERAL] some external sql not working in psql

2009-04-08 Thread Tom Lane
Kashmir writes: > being a sql-lamer, i used some query builder help to build my query (which > served me quite well in the past for all my 'complicated' sqls), and was > suggested for f_rrd_id=444 to use something as: > SELECT > td_fetch1m_by_rrd_id.f_timestamp, > td_fetch_by_rrd_id.f_ds, > td_f

[GENERAL] some external sql not working in psql

2009-04-08 Thread Kashmir
i'm in need of some psql advise, believe its rather a trivial issue, but confusing for me... (and hope this is the correct list for this?) facing following issue: got 2 tables like: CREATE TABLE td_fetch_by_rrd_id ( f_rrd_id numeric NOT NULL, f_timestamp numeric NOT NULL, f_ds numeric, f_