Quick Question

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Quick Question
Date: 2002-07-15 03:15:08
Message-ID: GNELIHDDFBOCMGBFGEFOKECCCDAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

How do you get this to work?

I'm creating a view of a table, but I'm trying to do something like
this:

create table t (
id integer not null,
amount numeric(7,2)
);

create view v as
select id as v_id,
'paid amount: ' || amount as v_comment
from t
;

You get this:

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-07-15 03:17:30 Sorry..
Previous Message Stephan Szabo 2002-07-14 19:46:53 Re: Indexes with LIKE