About OID and the commands/operators STRING( ... ) ..AS and +

Поиск
Список
Период
Сортировка
От Jarmo Paavilainen
Тема About OID and the commands/operators STRING( ... ) ..AS and +
Дата
Msg-id 001201c02579$3fcc5480$1501a8c0@theboss.comder.private
обсуждение исходный текст
Ответы Re: About OID and the commands/operators STRING( ... ) ..AS and +  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Hi,

I suspect that OID are reused, but how fast are they reused?

And does PostgreSQL support the STRING and AS command?

What I want to do is:

SELECT STRING( "IntegerKeyColumn" ) + STRING( "StringKeyColumn" ) +
TRING( "DoubleKeyColumn" ) AS STROID FROM "MyTable"

...and I want to be able to:

SELECT IntegerKeyColumn FROM "MyTable" WHERE
    STRING( "IntegerKeyColumn" ) + STRING( "StringKeyColumn" ) +
TRING( "DoubleKeyColumn" ) = [the result from previous select]

I would try it myself, but my PostgreSQL installation stopped working
(actually the whole computer is shutdown).

// Jarmo


В списке pgsql-general по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: running maintenance tasks on DB
Следующее
От: "Jarmo Paavilainen"
Дата:
Сообщение: Idea to a replication solution (warning: long, boring, OT? and possibly stupid)