Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to know how to select values from a column that has SERIAL data type.

I already try to do that but the output is like this 'Resource id #3', and not just '3'

I use SERIAL so I dont have to input ID like when I use integer

share|improve this question

closed as unclear what you're asking by dezso, ypercube, RLF, Colin 't Hart, Marian Apr 30 at 12:46

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer 1

There is no actual serial data type. serial is just a notational convenience.
The resulting data type is integer for serial or bigint for bigserial

Related answer on SO with more details:
Auto increment SQL function

You'd have to be more specific for a more specific answer.

share|improve this answer
3  
dba.stackexchange.com/questions/47098/… (self plug!) –  dezso Jul 3 '14 at 14:51

Not the answer you're looking for? Browse other questions tagged or ask your own question.