robe2

4 ms·

1. 1.▲
   by robe2 14y ago

   Our site is dedicated to that: http://www.postgresonline.com/ Also check out our new book which came out this month. http://shop.oreilly.com/product/0636920025061.do Its primary target audience are people coming from other relational d
2. 2.▲
   by robe2 14y ago

   CREATE USER is a standard in many relational databases e.g MySQL, PostgreSQL etc. You really shouldn't be inserting directly into mysql system tables. It's not portable. PostgreSQL has phppgadmin and pgAdmin which provide a nice GUI experi
3. 3.▲
   by robe2 14y ago

   Geography data type came out in 1.5 NOT 2.0. Raster and better 3D support were the big story in 2.0 But stay tuned for 2.1 --> Geography will become MUCH faster: http://blog.opengeo.org/2012/07/12/making-geography-faster/
4. 4.▲
   by robe2 14y ago

   You don't need to create a custom type to return tuples anymore. (that kind of went out with 8.1). You can use OUT parameters or RETURNS TABLE syntax. RETURNS TABLE is ANSI compliant and supported since 8.3. SQL Server supports RETURNS TA