On Tue, Nov 30, 2004 at 03:03:37PM -0800, Dann Corbit wrote:
> Using "SELECT * FROM <table_name>" from the PSQL prompt or any other interactive tool is perfectly fine.
>
> Putting "SELECT * FROM <table_name>" into a compiled program using libpq or ESQL is a code defect. Period.
This looks like misinformation, a misunderstanding of the data
available from libpq or a misunderstanding of how any language more
sophisticated than C[1] tends to access data structures
Would you care to expand on why you think this...
my $row = $dbh->selectrow_hashref("select * from $table");
print 'foo = ', $row{'foo'};
...is inherently a a code defect?
Cheers,
Steve
[1] Not that there's anything wrong with the moral equivalent of
PQgetvalue(res, 0, PQfnumber(res, "foo")) other than a slightly
clumsy syntax.