Re: [SQL] Function valid only for one table

2004-05-19 Thread Martin Knipper
Hi Tom, Am 19.05.2004 19:33 schrieb Tom Lane: > Martin Knipper <[EMAIL PROTECTED]> writes: > >>I thought about a mixture of object orientation and a normal table >>for a relational database. >>someFunction() is a method for the object/table someTable. > > Perhaps you could do what you want with

Re: [SQL] Function valid only for one table

2004-05-19 Thread Tom Lane
Martin Knipper <[EMAIL PROTECTED]> writes: > I thought about a mixture of object orientation and a normal table > for a relational database. > someFunction() is a method for the object/table someTable. Perhaps you could do what you want with functions accepting table rowtypes. create func

Re: [SQL] Function valid only for one table

2004-05-19 Thread Martin Knipper
Am 19.05.2004 18:33 schrieb Richard Huxton: > Martin Knipper wrote: > >>Hi there, >> >>is it possible to define a function that is only valid in a context >>of one table ? >> >>For Example: >> >>select someFunction() from someTable; >>-> OK >> >>select someFunction() from anotherTable; >>-> Error:

Re: [SQL] Function valid only for one table

2004-05-19 Thread Richard Huxton
Martin Knipper wrote: Hi there, is it possible to define a function that is only valid in a context of one table ? For Example: select someFunction() from someTable; -> OK select someFunction() from anotherTable; -> Error: someFunction unkown Um, no. What do you want someFunction() to do? -- Rich

[SQL] Function valid only for one table

2004-05-19 Thread Martin Knipper
Hi there, is it possible to define a function that is only valid in a context of one table ? For Example: select someFunction() from someTable; -> OK select someFunction() from anotherTable; -> Error: someFunction unkown Of course both tables are in the same database. Greetings, Martin -