RES: [GENERAL] Problem working with dates and times.

Michael Glaesemann wrote: ---Mensagem original- --De: Michael Glaesemann [mailto:[EMAIL PROTECTED] --Enviada em: segunda-feira, 4 de dezembro de 2006 19:44 --Para: Alejandro Michelin Salomon ( Adinet ) --Cc: Pgsql-General --Assunto: Re: [GENERAL] Problem working with dates and times

[GENERAL] Problem working with dates and times.

Hi : I have some problems working with date and times, in my web page. I have table with tasks. This table has : Inicial date Inicial hour Duration Final Date Final time Final Date and Final time are calculate based in Inicial date, Inicial hour, Duration. In my test: Inicial date

[GENERAL] Problem with function parameters

Hi : I have installed Pg 8.08 I create this function : CREATE OR REPLACE FUNCTION CALCULO_VALOR_LIQUIDO_HELPDESK( nTipoDesconto SMALLINT, nTipoComissao SMALLINT, nDesconto

RES: [GENERAL] Problem with function parameters

Richard Huxton wrote: ---Mensagem original- --De: Richard Huxton [mailto:[EMAIL PROTECTED] --Enviada em: sexta-feira, 1 de dezembro de 2006 12:24 --Para: Alejandro Michelin Salomon ( Adinet ) --Cc: Pgsql-General --Assunto: Re: [GENERAL] Problem with function parameters -- -- --Alejandro

RES: [GENERAL] How to add days to date

Fuhr [mailto:[EMAIL PROTECTED] --Enviada em: terça-feira, 15 de agosto de 2006 22:17 --Para: Alejandro Michelin Salomon ( Adinet ) --Cc: Pgsql-General --Assunto: Re: [GENERAL] How to add days to date -- -- --On Tue, Aug 15, 2006 at 10:10:27PM -0300, Alejandro Michelin --Salomon ( Adinet ) wrote

[GENERAL] How to add days to date

Hi: I have problem trying to add same days to a date. I have this select : SELECT '2006-08-01' + FP.carencia + ( FP.prazo * ( MFP.parcela - 1 )) AS vencimento FROM fi_mov_formas_pagamento MFP LEFT OUTER JOIN fi_formas_pagamento FP ON ( MFP.idformapagamento = FP.idformapagamento AND

RES: [GENERAL] Ajax/PostgreSQL

Hi Paul : You can use deferred load do this. I am using tu active /deactive user without open a window and going to other page and return. No ajax in this code. -- // This is in the user form... -- head script type=text/javascript

RES: [GENERAL] php can't connect to postgresql server

Clodoaldo Pinto worte: ---Mensagem original- --De: [EMAIL PROTECTED] --[mailto:[EMAIL PROTECTED] Em nome de --Clodoaldo Pinto --Enviada em: segunda-feira, 3 de julho de 2006 12:13 --Para: pgsql-general postgresql.org --Assunto: Re: [GENERAL] php can't connect to postgresql server --

[GENERAL] Download pl/python

Title: Mensagem Hi : I want to use plpython. Where i can find and download pl/python for windows plattaform ? Help is apreciated. Thanks in advance. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.2/372 - Release Date:

RES: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully

What is real data for birthday - no birthday, n/a in date datatype representation ? For mysql is -00-00 and invalid date. For me is simple null, you have no data to put in the field. For me null is good in some situation, and bad in ohters. Just you have to think if you permit or not this

[GENERAL] PK with an expression in field list

Title: Mensagem Hi: I need create a PK for a table. This PK has 3 fields. PK is : CONSTRAINT ff_navios PRIMARY KEY ( idempresa, idarmador, UPPER( nome ) ) But seems not work. I have and other way to do this ? If this fields are not null and i create a unique index in place off pk, i

RES: [GENERAL] PK with an expression in field list

Hi : I will create a unique index, and make this fiels not null. Thanks for the reply. Alejandro Michelin Salomon ---Mensagem original- --De: Tom Lane [mailto:[EMAIL PROTECTED] --Enviada em: quarta-feira, 24 de maio de 2006 16:45 --Para: Alejandro Michelin Salomon ( Adinet ) --Cc

RES: [GENERAL] Installing PostGreSQL automatically

Hi Greg: The installer in win32, create a user named postgres, yes this user is not an administrator. And this is ok, security reasons. Alejandro Michelin Salomon Porto Alegre Brasil ---Mensagem original- --De: [EMAIL PROTECTED] --[mailto:[EMAIL PROTECTED] Em nome de Greg --Enviada em:

RES: [GENERAL] Let's make CPgAN!

Hi Florian : Oracle has packages. Packages are collections of functions, procedures, variables, constants, ect, put all together. You has two commands CREATE PACKAGES, CREATE PACKAGES BODY. CREATE PACKAGES this creates the definations, list of components, and the name. CREATE PACKAGES BODY

RES: [GENERAL] Add column and specify the column position in a table

Hi Ying: This feature seems by a mysql add tu create table command, only mysql can do dat. Alejandro Michelin Salomon ---Mensagem original- --De: [EMAIL PROTECTED] --[mailto:[EMAIL PROTECTED] Em nome de Emi Lu --Enviada em: quarta-feira, 17 de maio de 2006 18:21 --Para:

[GENERAL] Diferences between functions criated in pg 8.0.4 and criated in pg 7.4.8

Hi : I criated some function in my pg 8.0.4, they function as spected. But when i try tu criate this functions in my hosting that has pg 7.4.8, i can not do. I read documentation an i see some disferences. This is one of original function that i try to criate : CREATE OR REPLACE FUNCTION LEFT(

RES: [GENERAL] Diferences between functions criated in pg 8.0.4 and criated in pg 7.4.8

--Para: Alejandro Michelin Salomon ( Adinet ) --Cc: Pgsql-General --Assunto: Re: [GENERAL] Diferences between functions criated --in pg 8.0.4 and criated in pg 7.4.8 -- -- --On Sun, May 14, 2006 at 10:10:44AM -0300, Alejandro Michelin --Salomon ( Adinet ) wrote: -- Hi : -- -- I criated some function

RES: RES: [GENERAL] Diferences between functions criated in pg 8.0.4 and criated in pg 7.4.8

2006 11:50 --Para: pgsql-general@postgresql.org --Cc: Alejandro Michelin Salomon ( Adinet ); 'Martijn van Oosterhout' --Assunto: Re: RES: [GENERAL] Diferences between functions --criated in pg 8.0.4 and criated in pg 7.4.8 -- -- --The first thing to check is whether the hosting service has

[GENERAL] How to add plPHP to Postgresql

Title: Mensagem Hi : How to add the plPHPto the postgresqlserver, without recompiling the server? Thanks in advance Alejandro Michelin Salomon Porto Alegre Brasil --No virus found in this outgoing message.Checked by AVG Free Edition.Version: 7.1.392 / Virus Database: 268.5.5/333 -

RES: [GENERAL] Creating a function that acept any data type

Michelin Salomon ( Adinet ) Cc: Pgsql-General Assunto: Re: [GENERAL] Creating a function that acept any data type On Fri, Mar 10, 2006 at 05:12:53PM -0300, Alejandro Michelin Salomon ( Adinet ) wrote: I am working in a migration. Im am migrating systems based in mysql to postgresql. I am

[GENERAL] Creating a function that acept any data type

Hi : I am working in a migration. Im am migrating systems based in mysql to postgresql. I am trying to create a function named IFNULL, to not migrate any ocurrence of this mysql function in my code. The IFNULL function is the same of COALESCE in postgresql. This code does not work. CREATE OR