Re: [SQL] index compatible date_trunc in postgres?

On Thu, Dec 18, 2008 at 10:46 PM, Bryce Nesbitt wrote: > I've got a legacy app that does 8.3 incompatible date searches like so: > explain select count(*) from contexts where publication_date like '2006%'; > explain select count(*) from contexts where publication_date like > '2006-09%'; > > I've g

[SQL] index compatible date_trunc in postgres?

I've got a legacy app that does 8.3 incompatible date searches like so: explain select count(*) from contexts where publication_date like '2006%'; explain select count(*) from contexts where publication_date like '2006-09%'; I've got my choice of refactoring, but all these share the same sequentia

Re: [SQL] Re: How to insert Images(bnp,png,etc) into Postgresql and how to retrive the inserted Imaged using C#.net

venkat wrote: HI Milen, Thanks for your great response,I do not find anything like insert images.. I have seen the whole tutorial..Please can you give me some example to insert images into postgresql. I am waiting for your great response. PostgreSQL has a general binary datatype called "

Re: [SQL] Re: How to insert Images(bnp,png,etc) into Postgresql and how to retrive the inserted Imaged using C#.net

HI Milen, Thanks for your great response,I do not find anything like insert images.. I have seen the whole tutorial..Please can you give me some example to insert images into postgresql. I am waiting for your great response. Thanks, Venkat. On Thu, Dec 18, 2008 at 8:02 PM, Milen A. Radev wro

[SQL] Re: How to insert Images(bnp,png,etc) into Postgresql and how to retrive the inserted Imaged using C#.net

venkat написа: > Dear All, > > I want to insert Images(bnp,png,etc) into Postgresql and how to retrieve > the inserted Imaged using C#.net.I do not know where to start? Any one can > help me. [...] Start here - http://npgsql.projects.postgresql.org/docs/manual/UserManual.html and look for "W

[SQL] How to insert Images(bnp,png,etc) into Postgresql and how to retrive the inserted Imaged using C#.net

Dear All, I want to insert Images(bnp,png,etc) into Postgresql and how to retrieve the inserted Imaged using C#.net.I do not know where to start? Any one can help me. I am waiting for your great response. Advanced Thanks, Venkat.