From 9cc5674c435b2e18e23f06fe9dc6eb9f78962c89 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sun, 29 Jan 2006 21:08:37 +0000 Subject: [PATCH] Another gotcha --- dev/pgsql_info.txt | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/dev/pgsql_info.txt b/dev/pgsql_info.txt index a3eaaff..06eaeae 100644 --- a/dev/pgsql_info.txt +++ b/dev/pgsql_info.txt @@ -13,4 +13,5 @@ $Id$ - Need change limiting agent from "LIMIT offset,max" and PGSQL uses "LIMIT max OFFSET offset" - Fulltext searching is not supported in PGSQL, will need to rewrite searches to allow for some degree of niceness - Need DB-specific DB->insert_id() for MySQL and DB->insert_id(table, column) for PGSQL -- FIND_IN_SET(find, field) needs to be "find = ANY(STRING_TO_ARRAY(field, ','))" \ No newline at end of file +- FIND_IN_SET(find, field) needs to be "find = ANY(STRING_TO_ARRAY(field, ','))" +- Blobs need to become bytea fields; when inserting into them, pg_escape_bytea() needs to be run and when outputting it pg_unescape_bytea() needs to be run on the output \ No newline at end of file -- 2.22.5