On Mon, 2008-01-07 at 17:03 -0500, Emi Lu wrote:
> select ?max?(col1, col2, col3) as result;
> will return
>
> result
> ---
> 5
> 8
> 12
>
> (3 rows)
8.1 (I believe?) introduced GREATEST(), which does precisely what you're
looking for.
But if 8.0 is a must, you'll probably have to create yo
L statement:
> INSERT INTO TABLE2 (TE_INDI) VALUES ('SANT'ANGELO LODIGIANO');
INSERT INTO TABLE2 (TE_INDI) VALUES SELECT TE_INDI FROM TABLE1 WHERE (...)
No quoting or server->client->server worries to deal with at all...
Best of luck,
- Josh Williams
---
t;SELECT * FROM $tablename" | while etc
Worst case, you'll end up with a messy $leftside and $rightside variable set.
To answer the original question, the field must be hard coded either as a list
or that perhaps over-used(?) asterisk. If you really need to pull and use t
