Tweak sql result set... ?

From: Axe <info(at)axier(dot)se>
To: pgsql-sql(at)postgresql(dot)org
Subject: Tweak sql result set... ?
Date: 2009-07-28 20:49:29
Message-ID: 2981e447-3f11-4002-92fb-06a6af39762e@c29g2000yqd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a problem where I want to tweak a simple select in an
"unobtrusive way". Imagine I have the following select statement:
"SELECT name FROM customer LIMIT 1" and I get a normal result set from
this. But, could I,maybe by defining some other function or similar,
change the result set *without* changing the query? Suppose I get the
result from the query above, saying: "Peter Peterson". I would
(sometimes) like to get the result "<div>Peter Peterson</div>" but I
should not have to change the original query.

I know I could write "SELECT '<div>' || name || '</div>' as name FROM
customer" but then I have altered the original query and I cannot do
this since it is supposed to function different in two different
situations.

Any ideas on how to achieve this? I would like to let the original sql
code stay original. I can prepare postgres before executing the sql if
this makes it easier to acheive the goal

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message nha 2009-07-28 21:10:53 Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL
Previous Message Rob Sargent 2009-07-28 20:08:51 Re: Detect referential integrity structure