throw date - Search results in mailing lists
Mailing lists >> pgsql-sql >> Thread
2011-07-19 08:30:41 | Re: to_char() accepting invalid dates? (Thomas Kellerer)
throws an error for the above example: SQL> select to_date('20110231', 'YYYYMMDD') from dual
Mailing lists >> pgsql-sql >> Thread
2010-02-01 15:42:52 | Re: Crosstab Confusion (Lee Hachadoorian)
date)? They must successfully pass an "equals" test to get included in the right crosstab cell. If a category value in the source query doesn't match any value produced by the category query
Mailing lists >> pgsql-sql >> Thread
2008-12-19 09:32:32 | Re: index compatible date_trunc in postgres? (Tom Lane)
date::text, in which case just throwing in the cast will produce the same results
Mailing lists >> pgsql-sql >> Thread
2008-12-09 14:37:13 | Re: inconsistent automatic casting between psql and function (Tom Lane)
date, it will happily throw away any additional time-of-day fields that might be in there
Mailing lists >> pgsql-sql >> Thread
2008-04-24 11:42:49 | Re: First day of month, last day of month (Bart Degryse)
date_trunc('month', ...) you throw away anything smaller than month in one step. I suppose
Mailing lists >> pgsql-sql >> Thread
2008-04-11 11:41:05 | Re: Testing for null record in plpgsql (Erik Jones)
dates will be difficult) and a test suite written I'll probably throw it up on github
Mailing lists >> pgsql-sql >> Thread
2007-06-22 14:54:19 | Re: [Fwd: 47G file] (Wei Weng)
date: 2007-02-05 23:21:05 +0000; author: alex; state: Exp; lines: +1 -1 * Merge from R7100_bugfixes_branch * Bug: Unicast delivery throw
Mailing lists >> pgsql-sql >> Thread
2006-10-16 03:17:40 | Re: Recursive pl/pgsql function ... (Marc G. Fournier)
throw any date at it, it seems, but I can't use it as a 'field
Mailing lists >> pgsql-sql >> Thread
2005-08-20 11:54:22 | Problem with self-made plpgsql-function / casting (Moritz Bayer)
throws the following exception: ERROR: function public.fc_editlanguage(integer, "unknown", "unknown", integer) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts
Mailing lists >> pgsql-sql >> Thread
2005-04-18 18:11:58 | Re: About "Alter table... alter column.. TYPE ... " (Rod Taylor)
throw away information. That is, in cases where it believes you may lose data, it will not perform it. That said, you can coax it into doing so. ALTER TABLE test ALTER COLUMN col TYPE
Mailing lists >> pgsql-sql >> Thread
2004-10-20 08:04:14 | SQL update function faililed in Webmin Interface (Kathiravan Velusamy)
throws me following error when i saved it : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "SQL update "one" set Name = 'Second1' where oid = 25349 failed : column "name" of relation "one" does not exist". ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ But when i created the database without using this
Mailing lists >> pgsql-sql >> Thread
2004-08-29 12:17:25 | expression_tree_walker: Unexpected node type 711 (Ian Percival)
THROWING ERROR: select calendar_date from official_hour where official_hour is not null and office
Mailing lists >> pgsql-sql >> Thread
2004-04-06 10:12:30 | could not devise a query plan (SZŰCS Gábor)
date |szallitolevel_fajta | integer |szallitas | integer |tetelszam | integer |cikk | integer |minoseg | integer |mennyiseg | numeric(14,4) |fajta | integer |mennyisegi_egyseg | integer |hibastatusz | integer | %----------------------- cut here -----------------------% -- #1: This throws
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2004-02-20 11:35:24 | Re: date format in 7.4 (scott.marlowe)
date style said that march 14th should come in as 14/03/04. I.e. it's better at checking ranges and throwing
Mailing lists >> pgsql-sql >> Thread
2004-02-16 09:06:53 | Date format problems (Mark Roberts)
Hi im using the function below to insert data into my db; im using now