dynamic #include's?
От | Mark McArthey |
---|---|
Тема | dynamic #include's? |
Дата | |
Msg-id | CGEFKOCNLBFDGLJODOGIKEJCCDAA.mcarthey@execpc.com обсуждение исходный текст |
Список | pgsql-novice |
I have an idea for creating a Perl script, but I just wanted to make sure that no one has already created something similar. When doing a full row select, it's necessary to create all the bind variables, and then do a column by column select statement. Ugly if there's a lot of columns. I want to automagically create an include that I would be able to place in the DECLARE SECTION and also use in the SELECT statements. For example: EXEC SQL BEGIN DECLARE SECTION; #include "player_def.h" EXEC SQL END DECLARE SECTION; The #include'd file would contain the bind variables that were gathered from the database. Additionally, we should be able to do something like this: EXEC SQL SELECT #include "player_sel.h" INTO #include "player_bind.h" WHERE name = 'blah'; All of these methods are based upon my prior experience with embedded sql, so if Postgres has a better method, or something new has come up, please let me know. Thanks! Mark
В списке pgsql-novice по дате отправления: