Re: [GENERAL] What Programs Do You Use For PG?

2010-12-22 Thread Neil D'Souza
interesting project. do you have any documentation describing how it works? merlin Hi Merlin, Thank you for your interest in the project. Here is how to get it up and running so that you can try out the same application that you see running on: http://173.230.133.34:8080/ 0.

Re: [GENERAL] What Programs Do You Use For PG?

2010-12-20 Thread Neil D'Souza
You can have a look at my project on sourceforge: http://sourceforge.net/projects/proghelp builds applications with PG as a backend automatically. It uses a modified create table sql grammar as an input. 1. It automatically generates stored procedures to insert and retrieve data 2. a database api

Re: [GENERAL] Tools for form generation in PHP/HTML from database models/queries

2010-10-23 Thread Neil D'Souza
Hi Andre, Check out my project at: git://github.com/neilxdsouza/codehelper.git I'm using a modified create table syntax to generate forms - but my target language is C++/PostgreSQL using the Wt (witty) web toolkit. However, that does not mean you are restricted to C++ or Postgres or

Re: [GENERAL] a query on stored procedures/functions in pgsql

2010-10-20 Thread Neil D'Souza
> > You have same plpgsql identifiers as sql identifiers, and because > plpgsql identifiers has higher priority, your query is broken. For > simple functions like this don't use a plpgsql language - use sql > language instead. > Thank you for the quick reply. The example I constructed was specific

[GENERAL] a query on stored procedures/functions in pgsql

2010-10-20 Thread Neil D'Souza
consider the following sql statements: create table food(     food_code serial unique,     food_category varchar(20),     food_name varchar(20)     ); insert into food (food_category, food_name) values ('fruit', 'tomato'); insert into food (food_category, food_name) values ('fruit', 'banana'); in