On 2013-02-28, Marko Rihtar rihtar.ma...@gmail.com wrote:
--047d7b603fca8e330f04d6c63f7b
Content-Type: text/plain; charset=ISO-8859-1
Hi all,
i have a little problem.
cv1 := CONCAT(cv1, DECODE(TO_HEX(11), 'escape'));
what's that supposed to do? if I were to fix it how would I know?
On Thu, Feb 28, 2013 at 06:02:05PM +, Ben Morrow wrote:
Quoth m...@summersault.com (Mark Stosberg):
We are working on a project to start storing some data as soft deleted
(WHERE state = 'deleted') instead of hard-deleting it.
To make sure that we never accidentally expose the
Hi,
I need to fill up a sparse table in an view.
The table holds some numbers relating months and objects.
The month is an integer in the format MM.
To make it more convenient to manage this table I decidet to let a value
be good till the next entry.
E.g. if there is an entry in january
2013/3/2 Andreas maps...@gmx.net
So the table looks like.
my_numbers ( object_id int, month int, some_nr int )
( 17, 201301, 123 ),
( 42, 201301, 456 ),
( 42, 201303, 789 ),
Now I need a view that fills the gaps up till the current month.
( 17, 201301, 123 ),
( 17, 201302, 123 ),
Quoth lists-pg...@useunix.net (Wayne Cuddy):
On Thu, Feb 28, 2013 at 06:02:05PM +, Ben Morrow wrote:
(If you wanted to you could instead rename the table, and use rules on
the view to transform DELETE to UPDATE SET state = 'deleted' and copy
across INSERT and UPDATE...)
Sorry to
