quinta-feira, 9 de julho de 2009
Postgres Update - Alteracao de Dados na Tabela banco dados 09 07 09 05:43
UPDATE nome_tabela
SET coluna1=valor, coluna2=valor2
WHERE codigo_empresa=1
SET coluna1=valor, coluna2=valor2
WHERE codigo_empresa=1
Postgres formatacoes - 09 07 09 05:36
SELECT to_number('123,2', '999999999'); -- 1232
SELECT to_number('123,2', '9999999d99') -- 123.2
SELECT to_number('123,456,789.00', '999G999G999D99') AS formatted;
SELECT to_number('89', '00999999999')
SELECT to_number('$2,900.00', 'L9G999D99')
SELECT to_number('123,2', '9999999d99') -- 123.2
SELECT to_number('123,456,789.00', '999G999G999D99') AS formatted;
SELECT to_number('89', '00999999999')
SELECT to_number('$2,900.00', 'L9G999D99')
terça-feira, 7 de julho de 2009
quinta-feira, 2 de julho de 2009
drop function inc(int) ==> Eliminar funcao - 02 07 09 05:49
==== elimina funcao ====
drop function inc(int)
==== cria funcao ====
create or replace function inc(int)
returns int
as 'select $1 + 1'
language sql;
==== chama funcao ====
select inc(20)
drop function inc(int)
==== cria funcao ====
create or replace function inc(int)
returns int
as 'select $1 + 1'
language sql;
==== chama funcao ====
select inc(20)
Assinar:
Postagens (Atom)