Hi Misa, Tom & msi77,
On 16/05/12 00:21, Misa Simic wrote:
> SELECT id FROM generate_series(1,5) AS foo(id);
Thanks for the suggestions - all sorted!
cheers,
Jan
smime.p7s
Description: S/MIME Cryptographic Signature
On Tue, May 15, 2012 at 10:16 AM, Scott Marlowe wrote:
> On Tue, May 15, 2012 at 10:06 AM, Wes James wrote:
>> On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote:
>>> Wes James writes:
Why is there a different order on the different platforms.
>>>
>>> This is not exactly unusual. You should
On Tue, May 15, 2012 at 10:06 AM, Wes James wrote:
> On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote:
>> Wes James writes:
>>> Why is there a different order on the different platforms.
>>
>> This is not exactly unusual. You should first check to see if
>> lc_collate is set differently in the t
On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote:
> Wes James writes:
>> Why is there a different order on the different platforms.
>
> This is not exactly unusual. You should first check to see if
> lc_collate is set differently in the two installations --- but even if
> it's the same, there are
On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote:
> Wes James writes:
>> Why is there a different order on the different platforms.
>
> This is not exactly unusual. You should first check to see if
> lc_collate is set differently in the two installations --- but even if
> it's the same, there are
On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote:
> Wes James writes:
>> Why is there a different order on the different platforms.
>
> This is not exactly unusual. You should first check to see if
> lc_collate is set differently in the two installations --- but even if
> it's the same, there are
Both works fine:
SELECT generate_series AS id FROM generate_series(1,5);
and
SELECT id FROM generate_series(1,5) AS foo(id);
Technically dont know is there any differenece...
Thanks,
Misa
2012/5/15 Tom Lane
> Jan Bakuwel writes:
> > What I need is the ability to name the column in the vie
Jan Bakuwel writes:
> What I need is the ability to name the column in the view, ie.
> create view v as select 1 as "id" from func(5);
I think what you're looking for is the ability to re-alias a column name,
for example
select id from func(5) as foo(id);
regard
2012/5/14 Tom Lane
> Carlos Mennens writes:
> > I'm not understanding why I'm not able to change this column type from
> > char to integer?
>
> > forza=# ALTER TABLE customers
> > ALTER COLUMN cust_id TYPE integer;
> > ERROR: column "cust_id" cannot be cast to type integer
>
> Try "ALTER ... cu
When you select from function I think column name is the same as
function name. So if function name is func query would be:
SELECT func AS id FROM func(5);
Sent from my Windows Phone
From: Jan Bakuwel
Sent: 15/05/2012 08:02
To: pgsql-sql@postgresql.org
Subject: [SQL] SELECT 1st field
Hi,
I've
10 matches
Mail list logo
