How can I simply substatue a value in a query?

Поиск
Список
Период
Сортировка
От Roy Souther
Тема How can I simply substatue a value in a query?
Дата
Msg-id 1119892618.7882.4.camel@UtopiaPlanetia
обсуждение исходный текст
Ответы Re: How can I simply substatue a value in a query?
Re: How can I simply substatue a value in a query?
Список pgsql-sql
I want to do a simple substatution of a value in a query. For example I have a boolean field that wil return t or f
forTrue and False. I would like it to return Yes or No. I don't want to have a 2x2 table to look up the output. I don't
wantto use stored procedue.<br /><br /> I think there is a better way, somthing very simple but I cannot remember what
itis.<br /><table cellpadding="0" cellspacing="0" width="100%"><tr><td><br /><table cellpadding="0" cellspacing="0"
width="100%"><tr><td><u><ahref="mailto:roy@SiliconTao.com">Roy Souther</a></u><br /><u><a
href="http://www.SiliconTao.com">www.SiliconTao.com</a></u><br/> Let Open Source help your business move beyond.<br
/><br/> For security this message is digitally authenticated by <u><a href="http://www.gnupg.org">GnuPG</a></u>.
</td></tr></table><br/><br /><br /></td></tr></table> 

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

Предыдущее
От: Markus Bertheau ☭
Дата:
Сообщение: SELECT * FROM foo OFFSET -1 LIMIT 1
Следующее
От: "jimmy.olsen"
Дата:
Сообщение: pg_attribute.attlen -1 for varchar e pbchar fields