> -Original Message-
> From: Army [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 30, 2008 9:20 AM
> To: Derby Discussion
> Subject: Re: names of columns in VALUES
>
> Jim Newsham wrote:
> >
> > It seems there is no way to name the columns produced by the VALUES
> > keyword.
>
>
>
Jim Newsham wrote:
It seems there is no way to name the columns produced by the VALUES
keyword.
http://db.apache.org/derby/docs/dev/ref/rreftableexpression.html#rreftableexpression
ij> select * from (values ('aa', 'b')) AS
T(MYCOL,MYOTHERCOL);
MYCOL |MYOTHERC&
-
Jim Newsham wrote:
It seems there is no way to name the columns produced by the VALUES
keyword.
Select a, b, c from x, (values (“a”, “b”, “c”)) as y where x.a = y.1;
Two things with this statement:
1. String literals should be enclosed in single quotes
2. You can name the columns fr
Hi everyone,
It seems there is no way to name the columns produced by the VALUES keyword.
In ij, the output columns are always labeled 1, 2, 3, etc. Does this mean
the columns are unnamed and ij is just using numbers as labels, or are they
actually named "1", "2", "3", etc.? In any case, D
Hi,
I'm embedding derby on a Java Web Start application, and I want it to
automatically create and fill the database the first time it runs.
I'm using DdlUtils to create the tables, but it looks that it cannot fill
the tables with data.
I looked into JudoScript, and it seemed a great tool, bu
James A. Shepherd wrote:
Hi,
I added a comment to DERBY-3216 that means I believe it still affects
released version 10.3.2.1. Currently DERBY-3216 is closed. Can someone
reopen it please, or should I file a new jira?
https://issues.apache.org/jira/browse/DERBY-3216?focusedCommentId=1256