Quick Question - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Quick Question
Date
Msg-id GNELIHDDFBOCMGBFGEFOKECCCDAA.chriskl@familyhealth.com.au
Whole thread Raw
List 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:



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Indexes with LIKE
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Sorry..