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 ), <--
w: it's just an assumption,
you should write one yourself (on C for faster perfomance). Or simply use:
code1 + code
if your codes are of numeric type and are foreign keys to some other table's
primary key.
Please, give some feedback on usability of this solution.
--
Victor Yegorov
pgp0.pgp
Description: PGP signature
or me, and I cannot find the original post I've seen some
time ago.
I'm running:
`PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.95.3'.
Maybe someone came across with this and could help?
--
Victor Yegorov
pgp0.pgp
Description: PGP signature
n REWRITE RULES, but I can't get, how to create RULE to keep the
WHERE clause and separate one query into 2, and union them after.
Any suggestions?
--
Victor Yegorov
CREATE TABLE messages (
message_id INT4NOT NULL,
target VARCHAR(99),
client_id INT
