I have previously posted a question about getting Tcl, ODBC and
Postgresql to work together in comp.lang.tcl newsgroup and
Postgresql General mailing list but have received no responses.
Hopefully someone on this list can provide some help.
I recently upgraded to the latest version of Postgre
Try the folowing querys:
=> SELECT * FROM myTable ORDER BY myColumn DESC LIMIT
5;
That is exactly the last 5 rows of the query:
=> SELECT * FROM myTable ORDER BY myColumn;
Unfortunately, the tuples are in the opposite order
(thanks to DESC).
If the opposite order is a problem, I guess you cou
Hi
As a complete newbie to PGSQL -- and having searched the archives to no
avail -- the following error has been surfacing on a server that I have
just begun to work on (timing is everything ;-)
Error is
..
Database error: Invalid SQL: select val from active_sessions where sid =
'
The command:
SELECT (query) LIMIT m,n
gives m rows of the query's response, starting at row n+1, while
SELECT (query) LIMIT m
gives the first m rows of the query's response (starting at row 1).
Is there any easy way to get the *last* m rows of a query? I tried:
SELECT (query) LIMIT 5, -5
i
This message was sent from Geocrawler.com by "Nicholas Negulescu" <[EMAIL PROTECTED]>
Be sure to reply to that address.
Hi, I'm looking for a solution to the 8k limit on
text in Postgres. I want the text to be
searchable, so a large object is out. Does
anybody have a method to split text large
On Wed, 16 Feb 2000 [EMAIL PROTECTED] wrote:
> What's the quickest way to delete all PostgreSQL large objects? Is there a
> system table that lists the oids of existing large objects? I expect the
> command is something like:
>
> => select lo_unlink(SOME_ATTRIBUTE) from SOME_SYSTEM_TABLE
>
> bu
