Re: [GENERAL] Preserving the source code of views

2013-10-19 Thread Pavel Stehule
Hello 2013/10/20 Brian Crowell > Hello! I'm evaluating PostgreSQL as a replacement for SQL Server in our > in-house systems. I've been really impressed with it so far, and I'm eager > to try it with our data sets. > > I've run across one thing that would make a transfer difficult. Postgres > do

Re: [GENERAL] Preserving the source code of views

2013-10-19 Thread Gavin Flower
On 20/10/13 16:38, Brian Crowell wrote: Hello! I'm evaluating PostgreSQL as a replacement for SQL Server in our in-house systems. I've been really impressed with it so far, and I'm eager to try it with our data sets. I've run across one thing that would make a transfer difficult. Postgres doe

[GENERAL] Preserving the source code of views

2013-10-19 Thread Brian Crowell
Hello! I'm evaluating PostgreSQL as a replacement for SQL Server in our in-house systems. I've been really impressed with it so far, and I'm eager to try it with our data sets. I've run across one thing that would make a transfer difficult. Postgres doesn't preserve the source code for views, as f

[GENERAL] Cast user defined type to composite type

2013-10-19 Thread whiplash
Hello! I need use user defined type and operate it with low-level functions on language C. In databasepreferred using composite type. Can i write more performance casting that vector3_cast_vector3c? // in C typedef struct { x, y, z double; } vector3; input, output and other functions...

Re: [GENERAL] like & optimization

2013-10-19 Thread Scott Ribe
Thank you all. Both the double index & pg_trgm would be good solutions. On Oct 14, 2013, at 3:40 PM, Merlin Moncure wrote: > On Sat, Oct 12, 2013 at 4:28 PM, Torsten Förtsch > wrote: >> On 12/10/13 20:08, Scott Ribe wrote: >>> select * from test where tz >= start and tz < end and colb like '%fo