Probably the most succinct explanation would be to copy & paste from the
terminal...
tjhart=> create table a_line( foo line );
CREATE
tjhart=> insert into a_line ( foo ) values( '(0,0), (1,1)' );
ERROR: line not yet implemented
tjhart=> select version();
version
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> [ there's no cast from numeric to text ]
Feel free to contribute one.
In the bad old days when we couldn't distinguish explicit from implicit
cast functions, I was wary of adding new cast pathways. Too many
implicit casts and you have no t
Ignore previous half-completed email.
How do you get this to work in 7.2.1?
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_comme
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:
On Sat, 13 Jul 2002, Julian Scarfe wrote:
> From: "Stephan Szabo" <[EMAIL PROTECTED]>
>
> > You need to have made the database in C locale in order to get index scans
> > from LIKE. I think that's mentioned in the Localization section of the
> > admin guide, but I could be remembering that wrong
On Fri, 12 Jul 2002 17:32:50 +0200
"Luis Alberto Amigo Navarro" <[EMAIL PROTECTED]> wrote:
> Lineitem is being modified on run time, so creating a temp table don't
> solves my problem
> The time of creating this table is the same of performing the subselect (or
> so I think), it could be done cr
