Search Postgresql Archives

line CASE statemelnt in query a la Oracle

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I would like to have a query replace a NULL in  a field with a truncated value from one field based on a size passed in?

Basically, I'd like to be able to generate a 'short title' for a record based on either the user's input for  a short title, or a turncated 'normal title' at query time. 

Would this be very expensive processor timewise?

I might just feed the whole long title in and have the display properties of the browser truncate it.


Dennis Gearon

Signature Warning
----------------
EARTH has a Right To Life,
  otherwise we all die.

Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux