[SQL] How to call table returning function with other table

Hi. I have a function that is defined like (which works, sorry for the pseudocode) create type xxx as (id,...); create function calcuate_xxx (integer) returns xxx as $$ select $1, (select sum(amount) from bigtable where something) as a, (select sum(amount) from bigtable where some-other-thing

Re: [SQL] How to call table returning function with other table

2006/3/19, Svenne Krap <[EMAIL PROTECTED]>: > So it is something like "select xxx(id) from othertable where otherwhere > = 't'" except that it mangles the columns into an array. I have tried to > move the function-call into the fromlist (as it is usually done) but I > seem unsuccessful in getting

Re: [SQL] How to call table returning function with other table

Perfect. Thanks. Svenne Markus Bertheau wrote: 2006/3/19, Svenne Krap <[EMAIL PROTECTED]>: So it is something like "select xxx(id) from othertable where otherwhere = 't'" except that it mangles the columns into an array. I have tried to move the function-call into the fromlist (

[SQL] Lead and tail quotes with \pset fieldsep

Folks If I want psql to generate CSV files fully-double-quoted I can use pset as follows psql> \pset fieldsep "," However this does not put a quote before the first field and after the last, so each row comes out as 1234","blahblah","sdfgsg","foo","bar Is there a way to use psql to give rows like

Re: [SQL] Lead and tail quotes with \pset fieldsep

Bath, David wrote: > Folks > > If I want psql to generate CSV files fully-double-quoted I can > use pset as follows > psql> \pset fieldsep "," > However this does not put a quote before the first field and > after the last, so each row comes out as > 1234","blahblah","sdfgsg","foo","bar > > Is th

[SQL] PostgreSQL Handling of Special Characters

Hi to all, I am currently using PostgreSQL 8.0.3 My Database uses SQL_ASCII encoding. I have a program in Visual Basic that connects to PostgreSQL using ODBC Connection through File DSN. I insert a text in one fields of my table. For example, I insert a special character to that field. Let's s

Re: [SQL] PostgreSQL Handling of Special Characters

2006/3/20, Christian Paul B. Cosinas <[EMAIL PROTECTED]>: > Let's say a character of 150 ASCII code. Which looks like a hypen. > > When I retrieve the value of that field it gives me a question mark > character instead of that 150 ASCII code character. > > What could be the possible reason of thi

Re: [SQL] PostgreSQL Handling of Special Characters

Hi Markus, Can you please elaborate more on this. I'm really lost. Thank You So Much. -Original Message- From: Markus Bertheau [mailto:[EMAIL PROTECTED] Sent: Sunday, March 19, 2006 8:09 PM To: Christian Paul B. Cosinas Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] PostgreSQL Handling o

Re: [SQL] PostgreSQL Handling of Special Characters

Christian Paul B. Cosinas wrote: Hi Markus, Can you please elaborate more on this. I'm really lost. Be sure that postgresql ITSELF is handling all chars transparently except ZEROES. Look for the error in the media layer ---(end of broadcast)-

Re: [SQL] PostgreSQL Handling of Special Characters

Christian Paul B. Cosinas wrote: > My Database uses SQL_ASCII encoding. Do yourself a favor and use something else. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner wil

Re: [SQL] PostgreSQL Handling of Special Characters

My Database uses SQL_ASCII encoding. I just received an email with all accented characters destroyed. UNICODE should be the default for anything in 2006. ---(end of broadcast)--- TIP 6: explain analyze is your friend