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...)
>
>
2013/3/2 Andreas
> 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 ), <--
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 and
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 exp
On 2013-02-28, Marko Rihtar 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?
--
⚂⚃ 100% natur
