Search:     Advanced search
Browse by category:
Glossary | Contact Us

Database Knowledge Base / PostgreSQL /

i am writing a function to return a table in the select query i am using a join and for some columns i want to give alias name but alias name given within" " is not accepting pls give me some suggestions as soon as possible

Add comment
Views: 250
Votes: 2
Comments: 0
select a.answer as "choice",a.answerno as "choiceno",q.questionid,q.answer as "answerno",
q.solution,s.question from answer a , question q, qpselection s where (q.questionid=a.questionid )
and (s.questionid =a.questionid ) and s.qpid =$1

this is the query i tryed to run within the function
Others in this Category
document What is PostgreSQL? How is it pronounced?
document Who controls PostgreSQL?
document What is the copyright of PostgreSQL?
document What platforms does PostgreSQL support?
document Where can I get PostgreSQL?
document How does PostgreSQL compare to other DBMSs?
document Will PostgreSQL handle recent daylight saving time changes in various countries?
document What is the maximum size for a row, a table, and a database (PostgreSQL)?
document How we can perform MINUS (Oracle) Or EXCEPT (Maxdb) in MS Access?



RSS