Home » Developing U++ » U++ TheIDE and Library: Releases and ChangeLogs » PG SQL fixes changes...
PG SQL fixes changes... [message #10608] |
Wed, 18 July 2007 20:34 |
|
mirek
Messages: 13975 Registered: November 2005
|
Ultimate Member |
|
|
I have made a couple of fixes in PGSQL:
- DUAL_PRIMARY_KEY was not working
- I have added a support for binary columns (bytea); to store it, you need to use SqlRaw helper type and use textual form with '?' (not SqlExp) - just like in Oracle and for the same reasons too...
SQL.Execute("update MYTABLE set MYBINARYCOLUMN = ? where KEY = ?", SqlRaw(mybinaryvalue), mykey);
- In the process, I have removed Oid map - documentation states that standard types have fixed oids (makes sense to me), so I have reworked it into simple switch...
Off-topic, after some installation misery, I am starting to be quite happy with PG-SQL. So far, from developer's standpoint, it feels much better than Oracle...
|
|
|
|
Goto Forum:
Current Time: Sat May 04 03:28:16 CEST 2024
Total time taken to generate the page: 0.02171 seconds
|