Re: [BUGS] BUG #2852: User-defined type name begins with the

2006-12-22 Thread Bruce Momjian
I have applied the following documentaiton patch that states a leading underscore "shouldn't" be used, rather than prohibited. --- Pavel Golub wrote: > > The following bug has been logged online: > > Bug reference: 28

Re: [BUGS] BUG #2851: Error in documentation or in code?

2006-12-22 Thread Bruce Momjian
Interesting. The bug was caused because 'on' and 'off' both start with 'o', so the code didn't do tests for partial matches. The attached, applied patch will do the right thing, checking for at least two characters for 'on' and 'off'. The fix will appear in 8.3. ---

Re: [BUGS] BUG #2847: Bug with IN statement

2006-12-22 Thread Gurjeet Singh
On 12/21/06, Sandip <[EMAIL PROTECTED]> wrote: CREATE OR REPLACE FUNCTION sp_get_phase(character varying, character varying, character varying) RETURNS ret_dv_sp_get_phase AS $BODY$ SELECT BOOK_NO, USER_ID, COMPANY_ID, PHASE, UPDATE_USER_ID, UPDATE_DATE, AddInfo1