Hi all,
I have latest machine from HP with the following specs.
hpworkstation xw8200
Intel(R)Xeon(TM ) CPU 3.0Ghz
Operating System
Microsoft Windows XP
Professional x64 edition
version 2003
Service pack 1
Can any one help me
1. what is recommended version of numarray/Numpy? Bcoz numpy is not working bcoz Numpy is for win32.
...
artistlikeu
Last Activity: Sep 14 '07, 04:28 AM
Joined: Nov 3 '06
Location:
-
what is recommended version of numarray/Numpy on 64 bit OS?
-
Installation Issues
Hi all,
I been user of Postgresql on win32 operating system and Intel Pentium IV.
I have latest machine from HP with the following specs.
hpworkstation xw8200
Intel(R)Xeon(TM ) CPU 3.0Ghz
Operating System
Microsoft Windows XP
Professional x64 edition
version 2003
Service pack 1
Can any one help me
1. what are the recommended version... -
query and subquery in python
dear all
i am using postgresql data base....
is it possible to write a subquery in inside the main query in python program....
for example something like this.....
courses = db.query("selec t course_id, student_id, select course_coordina tor from teachers join course on teacher.course_ id=course.cours e_id, start_date from school)"
subquery .....student_id , select course_coordina tor from teachers... -
thnx dear Bartonc..... i put there also....... BUt i put some question there.... if u kindly have look..... sorry to bother u....
cheers... -
subquery!
dear all
is it possible to write a subquery in inside the main query in python program....
for example something like this.....
courses = db.query("selec t course_id, student_id, select course_coordina tor from teachers join course on teacher.course_ id=course.cours e_id, start_date from school)"
QUERy .....student_id , select course_coordina tor from teachers join course on teacher.course_ id=course.cours e_id........ -
Dear Bartonc,
is it applicable for postgresql also or only for MYSQL......
thnx...Leave a comment:
-
simulation data from Postgresql
i have connected database with python program.... this program is simulation using Simpy. i call all simulation data from Postgresql using pgdb.
is it possible that i can send some of results by using SQL queries back in the database. if is any hint plz???
regards -
retrieve column array values
i have a column which contains arrays of variable length. for example one array contains 5 elements, another contains 2 elements, another array 10 elements.
i have 500 records in this column
i want to select all elements of an array then below all elements of another array and so on in a normal column. this is very urgent if some body can help plz....
infact this operation is reverse to insert values from a column... -
retreive values from an array into column
Dear all,
can any one solve this problem.....
i have a table name as course which has following columns
cid as serial (PK)
course_id as int
student as int4[]
and course table looks like this
cid + course_id + students
1 +10 + {501,525,575}
2 +20 + {625,635,638,78 9,895}
3 +30 + {698,798,425,63 5}
i want to extract course_id and students in another... -
Dear Michael,
this results all value in one array. i want values respectively as i indicate din my expected result. If u can kindly give hint....
thnx...Leave a comment:
-
Dear Michael, i do not know how to put schema or tablhe. But my problem is simple. i once again explain it here. If u kindly have a look, i will be grateful 2 u.
i have a table school with two fields
course_id (int4).....
student_id (int4)
1) now many students share same course. i want to write a query that gives me course_id which has more than 5 students in a course.
my result should...Leave a comment:
-
Dear Michael
I m having another problem regarding (1-many relation). If u guide me.
i wrote a query which results to count the multiple values of an entry using count i.e.
select course_id, count(student_i d)
from school
GROUP BY course_id
having count(student_i d) > 5
this query gives me some results. i am interested to find which student id is against which course....1-many relationship....Leave a comment:
-
inserting values into array column
i have query result (25) rows. can i insert them into an column (array) in a table.
thnx -
postgis function
Hi all,
can someone give me a hint for one problem...
i have a linestring. it has start point coordinates, end point coordinates and of course length and each point has (x,y) coordinates pair. these x,y coordinates are stored in a separete table for every start and end point respectively . let suppose that length of linestring is 500 meter. i am at 300 meter away from end point of line string. i want to get my position in (x,y)... -
postgresql function
i am writing a function. my function gives multiple redords as result.
when i add a check (bool) constraint and call this function in check, error mess comes that sql query gives multiple records.Yes logically it should extrract one record for boolean check. Any hint ... or i have to add a loop in function so that my sql query must return single record.
thnx.... -
Dear Michael,
Thank you very much... it is solved.... and i got central point.
Cheers,,,,,,
2rtist...Leave a comment:
-
Dear Michael,
Thank you for sparing your time. But this already have done. This is not my problem. I tell you my problem in your example.
I have to find the first element of array i.e 1. I will use following query
"select f2[1] from foo;"
this will result i row and one element
f2
-----------------------
1
1 row
Now If i have 2000 rows i can find the first element of any array...Leave a comment:
-
invert an array
dear all,
i have an array which has some elements. I want to invert the sequence of elements.i.e i want that last number of array should become first number and vice versa.
thnx
@rtist -
This does not works.......??
may be there is a tricky query that can give the required result.??
any one can help in this regards????
thnx @rtist...Leave a comment:
-
accessing last element of an array
Dear all,
i have a column with data type array with variable size ...... e.g
number = [1,3,4,,7,54,98, 255]
i want to access the last element of this array.......
i accessed the first element by following statement....
select * from student where number =[1]
this worked fine....
BUT i am interested to access the last element using SQL command..... any suggestion plz........
No activity results to display
Leave a comment: