Strange syntax with select

From: "Edson F(dot) Lidorio" <edson(at)openmailbox(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Strange syntax with select
Date: 2015-12-25 13:23:01
Message-ID: 567D4335.1050506@openmailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I excuse my ignorance with SQL and my English.
I wonder if these procedures are correct or is it a bug?
I'm trying to put the result of a select within the v_saldo_ini
variable, except I realized that the postgresql created a table with
v_saldo_ini variable.

See the steps below:

CREATE TABLE contas
(
vlr_saldo_inicial numeric(14,2)) ;

select sum(vlr_saldo_inicial) as saldo_ini
into v_saldo_ini
from contas;

--postgresql created v_saldo_ini table

select * from v_saldo_ini;
saldo_ini
-----------
20000.00
(1 record)

--if I executat = ro select below, returns the table v_saldo_ini already
exists

select sum(vlr_saldo_inicial) as saldo_ini
into v_saldo_ini
from contas;

ERROR: relation "v_saldo_ini" already exists

I'm using version below PostgreSQL.

PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.9.2-10) 4.9.2, 64-bit

--
Edson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2015-12-25 14:45:33 Re: Strange syntax with select
Previous Message Amit Bondwal 2015-12-25 08:08:44 Re: BDR error while adding 3rd node to cluster