Re: [SQL] doubt

2007-05-19 Thread John DeSoi
On May 17, 2007, at 5:43 AM, S balasankaravadivel wrote: Shall i use \d command from the c program. If possible give me a example program. If you want to use the \d command in a C program, link your program to libpq and grab the C source code for the \d command from psql. Also, if you jus

[SQL] doubt

2007-05-19 Thread S balasankaravadivel
Shall i use \d command from the c program. If possible give me a example program. Office firewalls, cyber cafes, college labs, don't allow you to download CHAT? Click here: http://in.messenger.yahoo.com/webmessengerpromo.php

[SQL] Doubt with Joins

2006-10-02 Thread Ezequias Rodrigues da Rocha
Hi list,I have the following query:select distinct cli.id as id, cli.nome as Nome, c.numero as cardpass, cli.documento as Documento, cli.endereco as Endereco,cli.complemento as Complemento, cli.bairro as Bairro, cli.cidade as Cidade, cli.estado as UF, cli.cep as CEP, cli.telefone as Telefone, cli.

Re: [SQL] Doubt about User-defined function.

2006-07-15 Thread Aaron Bono
I am really confused about what your question is.  Functions can take zero to many arguments and return one value.  The argument types are different from (or at least are independent of) the return value.  Arguments are not returned, they are passed into the function.  Your use of the terminology a

[SQL] Doubt about User-defined function.

2006-07-15 Thread sathiya moorthy
   I have doubt about user-defined function returns value  : *  why function returns( accepts  ) One attribute in the arguments of function/table, Otherwise it returns the whole record of the table. Function accept more than arguments .       *   Why it doesn`t

[SQL] Doubt in stored procedure

2006-06-21 Thread satheesh Gnanasekaran
hi,      iam a novice in postgresql. i want to insert a values  to a table using stored procedure. plz mail me  the sample codes and examples. thanks in advance       with regards, Sathaa

Re: [SQL] Doubt :- Image_Insert

2004-11-22 Thread Rod Taylor
On Mon, 2004-11-22 at 15:09 +0100, Jerome Alet wrote: > Hi, > > On Mon, Nov 22, 2004 at 08:54:20AM -0500, Rod Taylor wrote: > > On Mon, 2004-11-22 at 19:11 +0530, sreejith s wrote: > > > Hello friends I have a doubt, > > > Is it possible to insert images into a postgres db. What is its > > > datat

Re: [SQL] Doubt :- Image_Insert

2004-11-22 Thread Jerome Alet
Hi, On Mon, Nov 22, 2004 at 08:54:20AM -0500, Rod Taylor wrote: > On Mon, 2004-11-22 at 19:11 +0530, sreejith s wrote: > > Hello friends I have a doubt, > > Is it possible to insert images into a postgres db. What is its > > datatype. Is its possible to insert jpeg images. or v have to store > > t

Re: [SQL] Doubt :- Image_Insert

2004-11-22 Thread Rod Taylor
On Mon, 2004-11-22 at 19:11 +0530, sreejith s wrote: > Hello friends I have a doubt, > Is it possible to insert images into a postgres db. What is its > datatype. Is its possible to insert jpeg images. or v have to store > the path into the db. Pls reply. its urgent. Use bytea for a datatype. Post

[SQL] Doubt :- Image_Insert

2004-11-22 Thread sreejith s
Hello friends I have a doubt, Is it possible to insert images into a postgres db. What is its datatype. Is its possible to insert jpeg images. or v have to store the path into the db. Pls reply. its urgent. Sreejith ---(end of broadcast)--- TIP 7: d

Re: [SQL] SQL doubt - Date Add

2004-10-11 Thread Richard Huxton
Gaetano Mendola wrote: sreejith s wrote: Hi friends, I problem is i want to add a specified no. of years to a given date ie, 12/12/2004 + 5 = 12/12/2009. This has to be done via sql. Any predefined function there for the same. or v have split the yr and then add. Sreejith # select '

Re: [SQL] Doubt

2004-09-28 Thread Paul Thomas
On 22/09/2004 12:11 S.Sreejith wrote: Sir, I am new to PostgreSQL. I have a doubt. Now i am doing one project in .NET technology with postgres(linux) as database. I am using pgADMIN and pgManager as tools for database releted activities. Now i am able to create functions with 'sql' language.