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: 14262
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: Thu Jun 26 11:10:07 CEST 2025
Total time taken to generate the page: 0.08468 seconds
|
Members
Pages
Help
Register
Login
Home
