I want to fetch a web page and parse links in that. I am using the foll. code
Code:
file =urllib.urlopen("file:///home/suresh/html_parser/Category:Sports.html")
content = file.read()
# Process the page.
But since the page contains UTF-8 content, its not able to parse it properly. But, if I save the page locally, then its able to parse. How to handle this problem,
Hello,
I am trying to code a simple udf in postgres. How do I write sql commands into pl/sql ? The foll. code doesnt work.
CREATE OR REPLACE FUNCTION udf()
RETURNS integer AS $$
BEGIN
for i in 1..2000 loop
for j in 1...10000 loop
end loop;
begin work;
declare cust scroll cursor for select * from tpcd.customer;
FETCH FORWARD 5 FROM cust;
end loop;...
How do I force a particular join in MSSQL eg.. I want to force a nested loop join over a merge join for a query to get the diff. in the executing times. I can do this in postgres with the conf file, how do achieve the same in MSSQL ?