[SQL] date range to set of dates expansion

2012-01-18 Thread Gary Stainburn
Hi, How can I expand a date range in a table to a set of date records? I have a table of availabilities thus: Column |Type | Modifiers ---+-+ aid

Re: [SQL] PostgreSQL Function

2012-01-18 Thread Pavel Stehule
Hello 2012/1/18 Rehan Saleem > hi > i want to create a function in postgresql that take input for columns from > user for example first_name , last_name, addres. and will put them into > table , and i also want to use exception if user enters wrong data. will > some one help me how can i create

[SQL] PostgreSQL Function

2012-01-18 Thread Rehan Saleem
hi  i want to create a function in postgresql that take input for columns from user for example first_name , last_name, addres. and will put them into table , and i also want to use exception if user enters wrong data. will some one help me how can i create thats function , because i am new to p

[SQL] Postgresql Function

2012-01-18 Thread Rehan Saleem
hi  i want to create a function in postgresql that take input for columns from user for example first_name , last_name, addres. and will put them into table , and i also want to use exception if user enters wrong data. will some one help me how can i create thats function , because i am new to p